0

Right now I am hosting PostgreSQLand 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?

Ola Ström
3011 gold badge3 silver badges10 bronze badges
asked Jun 17, 2016 at 2:37

2 Answers 2

1

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.

answered Jun 17, 2016 at 7:09
1

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.

answered Jun 17, 2016 at 19:48
1
  • Can you point me to something I can read about this? I want to set this up Commented Feb 25, 2017 at 8:49

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.