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