[Pgpool-general] PGpool tuning to improve performance

[Lazaro Rubén García Martinez]

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: pgpool-general-bounces at pgfoundry.org [pgpool-general-bounces at pgfoundry.org] En nombre de Sachin [sysadmin at indicussoftware.com]
Enviado el: martes, 28 de junio de 2011 8:38
Para: pgpool-general at pgfoundry.org
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
Pgpool-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general