Thanks for your reply. No we are not running OOM. ulimit o/p is as below.
[postg...@server1 ~]$ ulimit unlimited --- On Thu, 12/11/09, Richard Huxton <d...@archonet.com> wrote: From: Richard Huxton <d...@archonet.com> Subject: Re: [GENERAL] DB Restart To: "Sam Jas" <samja...@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? -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Connect more, do more and share more with Yahoo! India Mail. Learn more. http://in.overview.mail.yahoo.com/