As I know, Pgpool-II only balances the queries among backends, When a client connect to pgpool, Pgpool gives to client a sesion in that all select queries works, and it session is obtained by the parameters backend_weigh in pgpool.conf, with these parameters you can send more load to one server. If you need improve the performance of your queries, I recommend you to tuning your servers. Remember that pgpool is a program that intercepts every SQL query and sends it to one or all servers.
Regards. ________________________________________ De: [email protected] [[email protected]] En nombre de Sachin [[email protected]] Enviado el: martes, 28 de junio de 2011 8:38 Para: [email protected] Asunto: [Pgpool-general] PGpool tuning to improve performance Hello, I have pgpool & posgtres 8.4 installed successfully. Load balancing is also working average. I want to improve or boost up performance for load balancing. Right now, we are testing SELECT queries to database. Will you please guide us if somehow I'll able to improve it's performance.? Regards, Sachin _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
