Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41802=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Va9nH-0007jH-KF
 for pgsql-admin@arkaria.postgresql.org; Sat, 26 Oct 2013 19:45:07 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41802=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Va9nG-0007X4-V4
 for pgsql-admin@arkaria.postgresql.org; Sat, 26 Oct 2013 19:45:07 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <sfrost@tamriel.snowman.net>) id 1Va9nG-0007Wv-1c
 for pgsql-admin@postgresql.org; Sat, 26 Oct 2013 19:45:06 +0000
Received: from tamriel.snowman.net ([2001:4830:167b::11])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <sfrost@tamriel.snowman.net>) id 1Va9n9-0008Hv-Bs
 for pgsql-admin@postgresql.org; Sat, 26 Oct 2013 19:45:05 +0000
Received: by tamriel.snowman.net (Postfix, from userid 1000)
 id 6233D5F791; Sat, 26 Oct 2013 15:48:54 -0400 (EDT)
Date: Sat, 26 Oct 2013 15:48:54 -0400
From: Stephen Frost <sfrost@snowman.net>
To: =?utf-8?B?0JXQstCz0LXQvdC40Lkg0KHQtdC70Y/QstC60LA=?=
 <evg.selyavka@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: postgresql 9.1 out of memory
Message-ID: <20131026194854.GT2706@tamriel.snowman.net>
References: 
 <CAKPhvNY+LJV1MDTW=1KHX+igoUyyPVW8_V1-5+T18qBQ3CJGrw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature"; boundary="Xdkw5o8GYccqZ5Qy"
Content-Disposition: inline
In-Reply-To: 
 <CAKPhvNY+LJV1MDTW=1KHX+igoUyyPVW8_V1-5+T18qBQ3CJGrw@mail.gmail.com>
X-Editor: Vim http://www.vim.org/
X-Info: http://www.snowman.net
X-Operating-System: Linux/3.8.0-25-generic (x86_64)
X-Uptime: 15:47:28 up 105 days, 15:56,  5 users,  load average: 0.12, 0.08,
 0.06
User-Agent: Mutt/1.5.21 (2010-09-15)
X-Pg-Spam-Score: -2.3 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


--Xdkw5o8GYccqZ5Qy
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

=D0=95=D0=B2=D0=B3=D0=B5=D0=BD=D0=B8=D0=B9,

* =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:
> What other steps can I take to avoid such behavior in the future?

Monitor /proc/meminfo (specifically, Committed_AS vs. CommitLimit).  If
the amount of committed memory is getting up close to the commit limit,
you need to adjust something to use less memory- perhaps fewer shared
buffers, or lower work_mem, etc.

	Thanks,

		Stephen

--Xdkw5o8GYccqZ5Qy
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)

iEYEARECAAYFAlJsHKYACgkQrzgMPqB3kigtDwCcC4I1qM7yzU6iCcNgRdZG/CrH
TcEAnjLBrPsqyCpZdgpcG6qoFUhiM03B
=xIyK
-----END PGP SIGNATURE-----

--Xdkw5o8GYccqZ5Qy--