Re: DB Restart

Thanks for your reply.

No we are not running OOM. ulimit o/p is as below.

[postgres(at)server1 ~]$ ulimit
unlimited

--- On Thu, 12/11/09, Richard Huxton <dev(at)archonet(dot)com> wrote:

From: Richard Huxton <dev(at)archonet(dot)com>
Subject: Re: [GENERAL] DB Restart
To: "Sam Jas" <samjas33(at)yahoo(dot)com>
Cc: "general" <pgsql-general(at)postgresql(dot)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(at)postgresql(dot)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/