Re: postgresql 9.1 out of memory - Mailing list pgsql-admin

From Stephen Frost
Subject Re: postgresql 9.1 out of memory
Date
Msg-id 20131026194854.GT2706@tamriel.snowman.net
Whole thread Raw
In response to postgresql 9.1 out of memory  (Евгений Селявка <evg.selyavka@gmail.com>)
List pgsql-admin
Евгений,

* Евгений Селявка (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

Attachment

pgsql-admin by date:

Previous
From: David Johnston
Date:
Subject: Re: postgresql 9.1 out of memory
Next
From: Patrick Dung
Date:
Subject: Re: ZFS-FreeBSD + postgresql performance