Hi, I am working on a POC of setting up PGPOOL with postgresql for failover and recovery.
Everything is working fine but I am observing huge performance delay with transaction. Following is my setup.. PGPOOL : Running on separate Amazon Instance (Used for fail-over and recovery[No loa balancing and streaming replication]) POSTGRESQL DB: Setup on two different Amazon Instance with streaming replication setup . Application Server: Apache running on separate Amazon Instance and connect to pgpool which intern connected to postgresql servers. In normal scenario where Apache is directly connected to postgresql it takes 5 -7 seconds to complete the transaction... But if I am connecting through pgpool it is taking more than 40 seconds to complete the transaction. Note: How can I change the log level (PGPOOL logs all the statements tried to change the log level but it does not work) Please help me with the possibilities how can i improve the performance Regards, Praveen -- View this message in context: http://postgresql.1045698.n5.nabble.com/Performance-issue-when-using-pgpool-for-fail-over-and-recovery-of-postgresql-DB-tp5754820.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
