[Pgpool-general] pgpool-II 2.1 beta1 release

[Yoshiyuki Asaba]

Hi,

Thank you for the report.

From: Nico Schottelius <nico-pgpool at schottelius.org>
Subject: [Pgpool-general] pgpool-II 2.1 beta1 release
Date: Mon, 17 Mar 2008 17:06:34 +0100

> I am runnig 2.1beta1 right now and it looks good.
> Though we still have the multistatement issue:

It is a restriction. pgpool can't process mutistatement correctly.
You need to separate the query.

  PQexec("SET DateStyle=ISO");
  PQexec("SELECT oid, ...");


> I think I will do some performance tests, as currently pgpool-II-2.0.1 has
> worse results in some tests (as compared to pgpool-II-1):
> 
> - using pgbench
>    -c 128 -S results in 66k queries per second on pgpool-II-1,
>              (this in cpu limited, one cpu is 100% used by pgpool)
>              results in 52k queries per second on pgpool-II-2
>              (this in interupt limited, one cpu is 100% used by irqs)
>       Using three servers as backend

I do a performance test on pgpool-II 2.1 beta1 and pgpool-II 1.x.

* pgpoo.conf
  replication_mode = true
  load_balance_mode = true
  backend_hostname0 = 'host1'
  backend_port0 = 5432
  backend_weight0 = 1
  backend_hostname1 = 'host2'
  backend_port1 = 5432
  backend_weight1 = 1

* Database

  % createdb -p 9999 bench
  % pgbench -p 9999 -i bench


* Test result
pgpool-II 1.x:

  % pgbench -p 9999 -c 30 -t 50000 -S bench
  starting vacuum...end.
  transaction type: SELECT only
  scaling factor: 1
  number of clients: 30
  number of transactions per client: 50000
  number of transactions actually processed: 1500000/1500000
  tps = 25042.736682 (including connections establishing)
  tps = 25115.801846 (excluding connections establishing)

pgpool-II 2.1 beta:

  % pgbench -p 9999 -c 30 -t 50000 -S bench
  starting vacuum...end.
  transaction type: SELECT only
  scaling factor: 1
  number of clients: 30
  number of transactions per client: 50000
  number of transactions actually processed: 1500000/1500000
  tps = 28030.279205 (including connections establishing)
  tps = 28054.699482 (excluding connections establishing)

I could not see a performance difference. 
Could you try pgpool-II 2.1 beta in your test environment?

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp