Horton

Re: Temporary tables prevent autovacuum, leading to XID wraparound

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Michael Paquier <michael@paquier.xyz>, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>, tsunakawa.takay@jp.fujitsu.com, robertmhaas@gmail.com, pgsql-hackers@postgresql.org
Date: 2018-08-08T14:50:34Z
Lists: pgsql-hackers 
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> Unnoticed ABI breaks make my hair stand on end. 

Yeah.

> I'm unsure about pg11 -- is it a backbranch already or not?  Since we've
> released beta3 already, ISTM we should consider it so.

No.  See
https://www.postgresql.org/message-id/12725.1533737052%40sss.pgh.pa.us

At this point I'd judge it's still more valuable to minimize differences
between v11 and v12 than to avoid ABI breakages in v11.  It's unlikely
this would be the last ABI break before 11.0 anyway.

			regards, tom lane

Commits

  1. Clarify comment about assignment and reset of temp namespace ID in MyProc

  2. Make autovacuum more aggressive to remove orphaned temp tables

  3. Don't count background workers against a user's connection limit.