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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq