No we are not running OOM. ulimit o/p is as below.
[postgres@server1 ~]$ ulimit unlimited
--- On Thu, 12/11/09, Richard Huxton <dev@archonet.com> wrote:
From: Richard Huxton <dev@archonet.com> Subject: Re: [GENERAL] DB Restart To: "Sam Jas" <samjas33@yahoo.com> Cc: "general" <pgsql-general@postgresql.org> Date: Thursday, 12 November, 2009, 10:39 AM
Sam Jas wrote: > > > > Hi, > > We are facing issue with the RES memory. Below is the o/p of > top command. It shows that writer process reserved 3.8g. We have observed that > if it increased to 3.9g we need to restart the db. Otherwise it hangs. Kindly suggest us the good way to figure it out this issue. shared_buffer > is 3 GB.
Are you saying that you're running out of memory overall, or do you have a ulimit issue for the postgres user?