Re: out of memory

From: Fabricio <fabrixio1(at)hotmail(dot)com>
To: <alvherre(at)commandprompt(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: out of memory
Date: 2009-03-20 16:15:05
Message-ID: COL105-W713334FC286232FD3D4B95FE970@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks for answer Alvaro

Already i have memory overcommit disabled.
I've always had with the value 2

vm.overcommit_memory = 2

Fabricio

> Date: Wed, 18 Mar 2009 20:28:02 -0400
> From: alvherre(at)commandprompt(dot)com
> To: fabrixio1(at)hotmail(dot)com
> CC: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] out of memory
>
> Fabricio wrote:
> >
> >
> > Hi
> >
> > I have a dedicated database server with 16 GB of RAM.
> >
> > and the oom-killer is killing my database
>
> Try disabling memory overcommit; see 17.4.3 here:
> http://www.postgresql.org/docs/8.3/interactive/kernel-resources.html
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.

_________________________________________________________________
¿Conoces todas las novedades de Messenger?
www.messengernews.com.mx

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Caleb Cushing 2009-03-20 19:47:16 Re: pg_dump formatting
Previous Message Bruce Momjian 2009-03-20 14:31:35 Re: pg_dump formatting