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

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

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(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason Long 2010-11-08 19:06:13 Full Vacuum/Reindex vs autovacuum
Previous Message Jakub Ouhrabka 2010-11-08 19:05:23 Re: ERROR: Out of memory - when connecting to database