Postgres Pro
Downloads
Home   >   mailing lists

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

From hubert depesz lubaczewski
Subject Re: ERROR: Out of memory - when connecting to database
Date
Msg-id 20101108190532.GC17705@depesz.com
Whole thread Raw
In response to Re: ERROR: Out of memory - when connecting to database  (Jakub Ouhrabka <kuba@comgate.cz>)
Responses Re: ERROR: Out of memory - when connecting to database  (Jakub Ouhrabka <kuba@comgate.cz>)
List pgsql-general
Tree view 
On Mon, Nov 08, 2010 at 08:04:32PM +0100, Jakub Ouhrabka wrote:
> > is it 32bit or 64bit machine?
>
> 64bit
>
> > 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.

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

pgsql-general by date:

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