Re: Postmaster Out of Memory - Mailing list pgsql-general

From Tom Lane
Subject Re: Postmaster Out of Memory
Date
Msg-id 10747.1119935886@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postmaster Out of Memory  (Jeff Gold <jgold@mazunetworks.com>)
List pgsql-general
Jeff Gold <jgold@mazunetworks.com> writes:
> Tom Lane wrote:
>> TRUNCATE and CLUSTER both rebuild indexes, so they'd also trigger the
>> leak.

> Sorry to bug you again, but I have two quick followup questions: (1) is
> the leak you discovered fixed on the 8.0 branch? and (2) would closing
> the database connection once per day be a reasonable way to work around
> the problem in the absence of the patch you forwarded?

It is fixed in CVS-tip of all branches back to 7.3, but there is not any
release yet incorporating the fix.  Yes, closing your session and
starting a fresh one is a usable workaround.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: DANGER Windows version might hurt you
Next
From: "Magnus Hagander"
Date:
Subject: Re: automating backup ?