[Pgpool-general] pgpool-II 2.1 beta1 release

[Tatsuo Ishii]

> 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

It's not addressed in 2.1.

> 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):

Yeah...
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> - 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