Re: pgsql: Compute XID horizon for page level index vacuum on primary. - Mailing list pgsql-hackers

From Robert Haas
Subject Re: pgsql: Compute XID horizon for page level index vacuum on primary.
Date
Msg-id CA+TgmoYX_NpujURawaV-UH6HLSCsdjEw8-qxQ_DKM22BNRqYZw@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Compute XID horizon for page level index vacuum on primary.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql: Compute XID horizon for page level index vacuum on primary.  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-hackers
On Wed, May 1, 2019 at 12:50 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > Not strongly enough to argue about it very hard.  The current behavior
> > is a little weird, but it's a long way from being the weirdest thing
> > we ship, and it appears that we have no tangible evidence that it
> > causes a problem in practice.
>
> I think there's nothing that fails to suck about a hardwired "+ 10".

It avoids a performance regression without adding another GUC.

That may not be enough reason to keep it like that, but it is one
thing that does fail to suck.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: hyrax vs. RelationBuildPartitionDesc
Next
From: Alexander Kukushkin
Date:
Subject: Re: walsender vs. XLogBackgroundFlush during shutdown