Jeff Gold <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster