*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
>
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 on. The
reason is that the operations are slow, the termi
