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