On Thu, Nov 12, 2009 at 12:10 AM, Sam Jas <samjas33@xxxxxxxxx> 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. Oh yeah, how much memory does this machine have on it? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general