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