[Pgpool-general] pgpool II performance

[Jay Payne]

I'm running Postgres 8.1.11.   Here are the results of a pgbench test
pgbench -c 20 -t 1000 testdb
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 20
number of transactions per client: 1000
number of transactions actually processed: 20000/20000
tps = 731.350579 (including connections establishing)
tps = 732.860160 (excluding connections establishing)

I set up another environment with 3 servers 1 pgpool server and 2 masters
for master-master replication.  Everything on the pgpool functions great but
the performance is terrible.   Here are the results of the same pgbench test
run on the pgpool cluster.
pgbench -p 9999 -c 20 -t 1000 testdb
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 20
number of transactions per client: 1000
number of transactions actually processed: 20000/20000
tps = 443.242941 (including connections establishing)
tps = 443.912381 (excluding connections establishing)
tps = 401.669441 (excluding connections establishing)


All four servers have exactly the same hardware configuration.

Is this performance loss normal?

Thanks
--J
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20080306/4cc52ca7/attachment.html