<div dir="ltr"><div>Hello friends, how are you?<br><br></div><div>I have a big problem with database performance and need some help.<br><br></div><div>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.<br>
<br></div><div>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?<br>
<br></div><div>Thanks!<br></div><div></div><div></div><div><br>-- <br>José Renato Castro Milanez<br></div><div>Brazil<br>
</div></div>