[Pgpool-general] pgpool-II 2.1 beta1 release

[Nico Schottelius]

Hello Yoshiyuki,

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

2008-03-17 16:21:48 LOG:   pid 30152: statement: SET
DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS encoding,
datlastsysoid

which results in the error

2008-03-17 16:21:48 ERROR: pid 30152: pool_process_query: 1 th kind D
does not match with master connection kind C

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 also tried -c 64, -c 32, pgpool-II-1 is always faster (between 6-7k
queries per second).

Using pgbench without -S I get about
   60 queries per second with pgpool-II-1 (three backends)
   100 queries per second with pgpool-II-2 2.0.1 (three backends)
   240 queries per second with postgres directly

I am always using -t 50000 for -S and -t 5000 without -S.

Sincerly

Nico

-- 
Think about Free and Open Source Software (FOSS).
http://nico.schottelius.org/documentations/foss/the-term-foss/

PGP: BFE4 C736 ABE5 406F 8F42  F7CF B8BE F92A 9885 188C
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20080317/ffd7d133/attachment.bin