Re: DB Restart - Mailing list pgsql-general

From Richard Huxton
Subject Re: DB Restart
Date
Msg-id 4AFBE5DF.1020702@archonet.com
Whole thread Raw
In response to DB Restart  (Sam Jas <samjas33@yahoo.com>)
Responses Re: DB Restart  (Sam Jas <samjas33@yahoo.com>)
List pgsql-general
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
outthis 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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: knowing which table/schema is going to be chosen
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: knowing which table/schema is going to be chosen