Re: Temporary tables prevent autovacuum, leading to XID wraparound - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Temporary tables prevent autovacuum, leading to XID wraparound
Date
Msg-id 20180809070029.GF13638@paquier.xyz
Whole thread Raw
In response to Re: Temporary tables prevent autovacuum, leading to XID wraparound  (Andres Freund <andres@anarazel.de>)
Responses Re: Temporary tables prevent autovacuum, leading to XID wraparound
Re: Temporary tables prevent autovacuum, leading to XID wraparound
List pgsql-hackers
On Thu, Aug 09, 2018 at 08:32:32AM +0530, Andres Freund wrote:
> My point is that the documentation isn't sufficient. Not that there's an active problem.

OK.  Attached is the latest version if the patch I have that I was
preparing for commit.

On top of isTempNamespaceInUse I have this note:
+ * Note: this can be used while scanning relations in pg_class to detect
+ * orphaned temporary tables or namespaces with a backend connected to a
+ * given database.

Would you be fine if I add an extra note like what's in
BackendIdGetProc?  Say "The result may be out of date quickly, so the
caller must be careful how to handle this information."
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: buildfarm: could not read block 3 in file "base/16384/2662": readonly 0 of 8192 bytes
Next
From: Tatsuro Yamada
Date:
Subject: Typo in optimizer/README