Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Caleb CushingDate: 2009-03-20 19:47:16
Subject: Re: pg_dump formatting
Previous:From: Bruce MomjianDate: 2009-03-20 14:31:35
Subject: Re: pg_dump formatting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group