Re: DB Restart

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Sam Jas <samjas33(at)yahoo(dot)com>
Cc: general <pgsql-general(at)postgresql(dot)org>
Subject: Re: DB Restart
Date: 2009-11-12 13:52:18
Message-ID: dcc563d10911120552j5d7cb374ia04611e94e4d9052@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 12, 2009 at 12:10 AM, Sam Jas <samjas33(at)yahoo(dot)com> 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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Emanuel Calvo Franco 2009-11-12 14:07:15 Re: re-using RETURNING
Previous Message Scott Marlowe 2009-11-12 13:51:27 Re: DB Restart