İçereği Atla
Bu soru işaretlendi
postgresqlconnectionbitnamipostgresql9.3syslog
1 Cevapla
17412 Görünümler
Avatar
Sam path

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?

Thanks,

Sampath

Avatar
Vazgeç
Avatar
Axel Mendoza
En İyi Yanıt

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

https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

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

https://wiki.postgresql.org/wiki/Number_Of_Database_Connections

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


Avatar
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
Unable to run the PostgreSQL service Çözüldü
postgresql postgresql9.3
Avatar
Avatar
Avatar
Avatar
Avatar
6
Ara 23
45613
How do I mend a failed upgrade to Postgresql 9.3
postgresql postgresql9.3
Avatar
1
Mar 15
10184
[V9]postgresql connection error
error postgresql connection v9.0
Avatar
Avatar
Avatar
Avatar
4
Ara 22
12385
Docker: Odoo 15 failed connecting to Postgres DB
postgresql connection Docker v15
Avatar
Avatar
1
Kas 22
8739
How to represent Postgresql interval in Openerp 7 ?
postgresql python2.7 openerp7 postgresql9.3
Avatar
0
Eki 18
4113