Hi, I'm testing pgpool with load balancer and replication and it seems to be ok except the speed of SELECT queries.
The system is a test platform consist in 2 servers with pgpool and postgres installed in main one and a second one with only postgres. Please, look at this test. To backend0 directly: # pgbench -S -c100 -t100 -h192.168.100.52 -p4002 -Upostgres t1 starting vacuum...end. transaction type: SELECT only scaling factor: 1 number of clients: 100 number of transactions per client: 100 number of transactions actually processed: 10000/10000 tps = 9788.231609 (including connections establishing) tps = 15270.113029 (excluding connections establishing) To backend1 directly: # pgbench -S -c100 -t100 -h192.168.100.53 -p4003 -Upostgres t1 starting vacuum...end. transaction type: SELECT only scaling factor: 1 number of clients: 100 number of transactions per client: 100 number of transactions actually processed: 10000/10000 tps = 9592.298535 (including connections establishing) tps = 14526.712445 (excluding connections establishing) Using pgpool : # pgbench -S -c100 -t100 -h192.168.100.52 -p5432 -Upostgres t1 starting vacuum...end. transaction type: SELECT only scaling factor: 1 number of clients: 100 number of transactions per client: 100 number of transactions actually processed: 10000/10000 tps = 6299.831668 (including connections establishing) tps = 10573.026307 (excluding connections establishing) Some config lines from pgpool.conf : port = 5432 num_init_children = 300 max_pool = 2 replication_mode = true load_balance_mode = true Backend config is : backend_hostname0 = 'localhost' backend_port0 = 4002 backend_weight0 = 1 backend_data_directory0 = '/usr/local/pgpool/data-pp2' backend_hostname1 = '192.168.100.53' backend_port1 = 4003 backend_weight1 = 1 backend_data_directory1 = '/usr/local/pgpool/data-pp3' Anyone has experienced similar behavior ? TIA. _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
