Odoo Help


PostgreSQL Max connections

Sam path
on 2/22/16, 6:55 AM 2,167 views

Hi All,

I have installed a bitnami Odoo in Amazon EC2 m4.10xlarge  instance which has 40 vCPU, 160GB RAM and 500GB hard disk

By default PostgreSQL has a max_connections of 150 and I would need it to be increased to 100000(1Lakh connections)

May I know what changes do I have to do in postgresql.conf and sysctl.conf?



Axel Mendoza
On 2/22/16, 8:17 AM

You need to increase the max_connections settings in postgresql.conf according to this guide:


Normally you need to change: max_connections, shared_buffers and work_mem settings

but read it carefully for your environment, also I suggest you to use a connection pooling like pgbouncer according to this guide


Use the connection pooling to reach your number of max_connections instead of config postgresql to that insane value, read more about that here: http://www.cybertec.at/2014/03/max_connections-performance-impacts/

This are just a few tips, hope this helps

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 2/22/16, 6:55 AM
Seen: 2167 times
Last updated: 2/22/16, 8:17 AM