Re: Temporary tables prevent autovacuum, leading to XID wraparound

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com, robertmhaas(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Temporary tables prevent autovacuum, leading to XID wraparound
Date: 2018-08-08 16:42:29
Message-ID: 20180808164229.GA13638@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Aug 08, 2018 at 10:50:34AM -0400, Tom Lane wrote:
> Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
>> 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.

Thanks! Based on that I will get this patch into HEAD and 11 pretty
soon. v10 is definitely out of scope, even if it would have been
interesting to make autovacuum more aggressive there as well, as that's
where the last improvements have been done.
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2018-08-08 16:44:55 Re: REINDEX and shared catalogs
Previous Message Nico Williams 2018-08-08 16:39:51 Re: Have an encrypted pgpass file