*From:* Jeff Janes
*To:* Ioana Danes
*Cc:* PostgreSQL General
*Sent:* Thursday, May 16, 2013 9:56:07 AM
*Subject:* Re: [GENERAL] Running out of memory at vacuum
On Thu, May 16, 2013 at 6:35 AM, Ioana Danes <mailto:ioanasoftw...@yahoo
: Ioana Danes
Cc: PostgreSQL General
Sent: Thursday, May 16, 2013 9:56:07 AM
Subject: Re: [GENERAL] Running out of memory at vacuum
On Thu, May 16, 2013 at 6:35 AM, Ioana Danes wrote:
Hi Jeff,
>
>
>
>On Tuesday, May 14, 2013, Ioana Danes wrote:
>
>
>>
>The fix is t
On Thu, May 16, 2013 at 6:35 AM, Ioana Danes wrote:
> Hi Jeff,
>
> On Tuesday, May 14, 2013, Ioana Danes wrote:
>
>
> The fix is to restart postgres ... If I only close the connections the
> problem is still these so I need to restart postgres.
>
>
> How are you closing the connections?
>
> I res
Hi Jeff,
On Tuesday, May 14, 2013, Ioana Danes wrote:
Hi all,
>
>I have a production database that sometimes runs out of memory at nightly
>vacuum.
>
>The application runs typically with around 40 postgres connections but there
>are times when the connections increase because of some queries
On Tuesday, May 14, 2013, Ioana Danes wrote:
> Hi all,
>
> I have a production database that sometimes runs out of memory at nightly
> vacuum.
>
> The application runs typically with around 40 postgres connections but
> there are times when the connections increase because of some queries going
>
