0

Right now I am hosting postgresql and pgbouncer on the same Linode with 48GB of RAM and 12 Cores.

The server gets many short lived connections per second. The server load will increase with time and I want to reduce the server load as much as possible.

When I look at the 'top' command on the server, I see that pgbouncer is taking about 30% CPU usage. Would I benefit by creating another Linode and running pgbouncer on that server by itself?

0

The top command gives the CPU usage per core. Since you have 12 I would not create another Linode for that. Check the line with Cpu(s). There you will find the %id which is a better indication weather or not your server is using it's full CPU capacity.

0

If possible, rather than creating a new Linode(thanks for enlightening me), if you are able to create pgbouncer on the source (webserver or whatever) of the short lived connections, then you'll also save on the network time to make the connection.

  • Can you point me to something I can read about this? I want to set this up – Arya Feb 25 '17 at 8:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.