> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
