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

From Jeff Gold
Subject Re: Postmaster Out of Memory
Date
Msg-id 42C04F02.9030304@mazunetworks.com
Whole thread Raw
In response to Re: Postmaster Out of Memory  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Postmaster Out of Memory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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?

                                             Jeff

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Populating huge tables each day
Next
From: Catalin Constantin
Date:
Subject: performance for insert / update