DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
 b=P6vi9VHQM7HiIMS1YNIHXh0cft71Qsl1H86+lL1j5Mm/WVyLCpSXSfNqnD/zRuAK1V0fm2lQFySlVKMQdUlX7FGSxBiryMEB22riK8eYgLKdAQNxvvtLyqfYoFl5aQ77U9S+VQd2h2UarL1Q+000XqS73JdX35yimgDHmMd9PkM=;
References: 
 <CAKPhvNY+LJV1MDTW=1KHX+igoUyyPVW8_V1-5+T18qBQ3CJGrw@mail.gmail.com>
Message-ID: <1383146049.700.YahooMailNeo@web162906.mail.bf1.yahoo.com>
Date: Wed, 30 Oct 2013 08:14:09 -0700 (PDT)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: postgresql 9.1 out of memory
To: =?utf-8?B?0JXQstCz0LXQvdC40Lkg0KHQtdC70Y/QstC60LA=?=
 <evg.selyavka@gmail.com>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <CAKPhvNY+LJV1MDTW=1KHX+igoUyyPVW8_V1-5+T18qBQ3CJGrw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

=D0=95=D0=B2=D0=B3=D0=B5=D0=BD=D0=B8=D0=B9 =D0=A1=D0=B5=D0=BB=D1=8F=D0=B2=
=D0=BA=D0=B0 <evg.selyavka@gmail.com> wrote:

> Server HW:

> 32GB RAM

> Before server crash i have this parameters in config:
>
> max_connections =3D 350

> work_mem =3D 2GB

> After crash=C2=A0 i change this parameters:

> work_mem =3D 1GB

A good "rule of thumb" is to allow for one work_mem allocation per
connection for a reasonable estimation of peak memory usage for
this purpose.=C2=A0 (This may need to be adjusted based on workload, but
it's a reasonable place to start.)=C2=A0 So you have adjusted likely
peaks down from 700GB to 350GB.

I usually start with work_mem set to RAM * 25% / max_connections.
In your case that works out to 23MB.=C2=A0 If you are able to use a
connection pooler to reducee max_connections, that will allow you
to boost work_mem.

--=20
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin