Re: ERROR: Out of memory - when connecting to database

From: Jakub Ouhrabka <kuba(at)comgate(dot)cz>
To: depesz(at)depesz(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: Out of memory - when connecting to database
Date: 2010-11-08 19:10:43
Message-ID: 4CD84B33.8080206@comgate.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>> what's the work_mem?
>>
>> 64MB
>
> that's *way* too much with 24GB of ram and> 1k connections. please
> lower it to 32MB or even less.

Thanks for your reply. You are generally right. But in our case most of
the backends are only waiting for notify so not consuming any work_mem.
The server is not swapping. On the other hand some queries profit from
it. So we think it's fine as is.

Regards,

Kuba

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Barnes 2010-11-08 19:14:32 Re: ERROR: Out of memory - when connecting to database
Previous Message Jason Long 2010-11-08 19:06:13 Full Vacuum/Reindex vs autovacuum