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?
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
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 2/22/16, 6:55 AM|
|Seen: 967 times|
|Last updated: 2/22/16, 8:17 AM|