Re: ERROR: Out of memory - when connecting to database - Mailing list pgsql-general

From Jakub Ouhrabka
Subject Re: ERROR: Out of memory - when connecting to database
Date
Msg-id 4CD84B33.8080206@comgate.cz
Whole thread Raw
In response to Re: ERROR: Out of memory - when connecting to database  (hubert depesz lubaczewski <depesz@depesz.com>)
List 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


pgsql-general by date:

Previous
From: Jason Long
Date:
Subject: Full Vacuum/Reindex vs autovacuum
Next
From: Chris Barnes
Date:
Subject: Re: ERROR: Out of memory - when connecting to database