Thanks for your reply.
No we are not running OOM. ulimit o/p is as below.
[postgres@server1 ~]$ ulimit
unlimited
--- On Thu, 12/11/09, Richard Huxton <dev@xxxxxxxxxxxx> wrote:
From: Richard Huxton <dev@xxxxxxxxxxxx>
Subject: Re: DB Restart
To: "Sam Jas" <samjas33@xxxxxxxxx>
Cc: "general" <pgsql-general@xxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
|
Now, send attachments up to 25MB with Yahoo! India Mail.
Learn how.
