Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 36115633C4C
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 20 Mar 2009 13:15:08 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 14820-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 20 Mar 2009 13:15:05 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from col0-omc2-s12.col0.hotmail.com (col0-omc2-s12.col0.hotmail.com
	[65.55.34.86])
	by mail.postgresql.org (Postfix) with ESMTP id 25033633ACB
	for <pgsql-admin@postgresql.org>; Fri, 20 Mar 2009 13:15:06 -0300 (ADT)
Received: from COL105-W71 ([65.55.34.72]) by col0-omc2-s12.col0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.3959);
	Fri, 20 Mar 2009 09:15:04 -0700
Message-ID: <COL105-W713334FC286232FD3D4B95FE970@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_bd46865c-0556-419a-9b74-390e9ece4d44_"
X-Originating-IP: [201.147.232.187]
From: Fabricio <fabrixio1@hotmail.com>
To: <alvherre@commandprompt.com>
CC: <pgsql-admin@postgresql.org>
Subject: Re: out of memory
Date: Fri, 20 Mar 2009 09:15:05 -0700
Importance: Normal
In-Reply-To: <20090319002802.GO3798@alvh.no-ip.org>
References: <COL105-W45BE0DADEA114A6000C945FE9F0@phx.gbl>
	<20090319002802.GO3798@alvh.no-ip.org>
MIME-Version: 1.0
X-OriginalArrivalTime: 20 Mar 2009 16:15:04.0901 (UTC)
	FILETIME=[07832F50:01C9A977]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.655 tagged_above=0 required=5 tests=AWL=0.654,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200903/204
X-Sequence-Number: 31704

--_bd46865c-0556-419a-9b74-390e9ece4d44_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



Thanks for answer Alvaro
=20
Already i have memory overcommit disabled.
I've always had with the value 2

vm.overcommit_memory =3D 2

Fabricio

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

_________________________________________________________________
=BFConoces todas las novedades de Messenger?
www.messengernews.com.mx=

--_bd46865c-0556-419a-9b74-390e9ece4d44_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style>
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
</style>
</head>
<body class=3D'hmmessage'>
<br>Thanks for answer Alvaro<br>&nbsp=3B<br>Already i have memory overcommi=
t disabled.<br>I've always had with the value 2<br><br>vm.overcommit_memory=
 =3D 2<br><br>Fabricio<br><br>&gt=3B Date: Wed=2C 18 Mar 2009 20:28:02 -040=
0<br>&gt=3B From: alvherre@commandprompt.com<br>&gt=3B To: fabrixio1@hotmai=
l.com<br>&gt=3B CC: pgsql-admin@postgresql.org<br>&gt=3B Subject: Re: [ADMI=
N] out of memory<br>&gt=3B <br>&gt=3B Fabricio wrote:<br>&gt=3B &gt=3B <br>=
&gt=3B &gt=3B <br>&gt=3B &gt=3B Hi<br>&gt=3B &gt=3B <br>&gt=3B &gt=3B I hav=
e a dedicated database server with 16 GB of RAM.<br>&gt=3B &gt=3B <br>&gt=
=3B &gt=3B and the oom-killer is killing my database<br>&gt=3B <br>&gt=3B T=
ry disabling memory overcommit=3B see 17.4.3 here:<br>&gt=3B http://www.pos=
tgresql.org/docs/8.3/interactive/kernel-resources.html<br>&gt=3B <br>&gt=3B=
 -- <br>&gt=3B Alvaro Herrera                                http://www.Com=
mandPrompt.com/<br>&gt=3B The PostgreSQL Company - Command Prompt=2C Inc.<b=
r><br /><hr />Personaliza=2C comparte y comun=EDcate  <a href=3D'www.messen=
gernews.com.mx' target=3D'_new'>como nunca antes en Messenger</a></body>
</html>=

--_bd46865c-0556-419a-9b74-390e9ece4d44_--