Евгений Селявка <evg.selyavka@xxxxxxxxx> wrote: > Server HW: > 32GB RAM > Before server crash i have this parameters in config: > > max_connections = 350 > work_mem = 2GB > After crash i change this parameters: > work_mem = 1GB A good "rule of thumb" is to allow for one work_mem allocation per connection for a reasonable estimation of peak memory usage for this purpose. (This may need to be adjusted based on workload, but it's a reasonable place to start.) So you have adjusted likely peaks down from 700GB to 350GB. I usually start with work_mem set to RAM * 25% / max_connections. In your case that works out to 23MB. If you are able to use a connection pooler to reducee max_connections, that will allow you to boost work_mem. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
