Re: postgresql 9.1 out of memory
| От | Kevin Grittner |
|---|---|
| Тема | Re: postgresql 9.1 out of memory |
| Дата | |
| Msg-id | 1383146049.700.YahooMailNeo@web162906.mail.bf1.yahoo.com обсуждение исходный текст |
| Ответ на | postgresql 9.1 out of memory (Евгений Селявка <evg.selyavka@gmail.com>) |
| Список | pgsql-admin |
Евгений Селявка <evg.selyavka@gmail.com> 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
В списке pgsql-admin по дате отправления: