Re: DB Restart

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?

--
  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