[pgpool-general: 2470] Re: Best pgpool configuration to divide cpu utilization

[Lazaro Ruben Garcia Martinez]

I think you could use master slave with streaming replication, and pgpool for load balancing, connection pooling and try to use query cache.

Regards.
________________________________________
De: pgpool-general-bounces at pgpool.net [pgpool-general-bounces at pgpool.net] En nombre de José Renato Castro Milanez [jrcmilanez at gmail.com]
Enviado el: martes, 21 de enero de 2014 14:15
Para: pgpool-general at pgpool.net
Asunto: [pgpool-general: 2466] Best pgpool configuration to divide cpu  utilization

Hello friends, how are you?

I have a big problem with database performance and need some help.

My postgresql server (latest 9.3 version, 16 cores, 42 gb of ram) have just a couple of databases. One, in particular, have some heavy queries implemented via procedures. When running with a lot of users (500 users), my cpu utilization goes very high and the overall execution query time also increases.

For better performance, I have a man already working on these slow queries. But to be safer, I'd like to add more servers to reduce the execution times. So, what´s the best approach for me? pgpool with replication mode, load balance and query cache? or master/slave approach?

Thanks!

--
José Renato Castro Milanez
Brazil

________________________________
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com