Re: DB Restart

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