Re: postgresql 9.1 out of memory

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Евгений Селявка <evg(dot)selyavka(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: postgresql 9.1 out of memory
Date: 2013-10-26 19:48:54
Message-ID: 20131026194854.GT2706@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Евгений,

* Евгений Селявка (evg(dot)selyavka(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ivailo.TANUSHEFF 2013-10-28 06:55:29 Re: ZFS-FreeBSD + postgresql performance
Previous Message David Johnston 2013-10-26 19:18:46 Re: postgresql 9.1 out of memory