Re: pgsql: Compute XID horizon for page level index vacuum on primary.

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-committers(at)lists(dot)postgresql(dot)org,Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>,pgsql-committers <pgsql-committers(at)lists(dot)postgresql(dot)org>
Subject: Re: pgsql: Compute XID horizon for page level index vacuum on primary.
Date: 2019-03-28 15:27:27
Message-ID: DB9129B1-D730-4FA2-824D-471DA0F57399@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Hi,

On March 28, 2019 11:24:46 AM EDT, Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
>On Thu, Mar 28, 2019 at 5:28 AM Andres Freund <andres(at)anarazel(dot)de>
>wrote:
>> Hm, good catch. I don't like this fix very much (even if it were
>> commented), but I don't have a great idea right now.
>
>That was just a POC, to verify the problem. Not a proposal.

I'm mildly inclined to push a commented version of this. And add a open items entry. Alternatively I'm thinking of just but taking the tablespace setting into account.

Andres

Andres
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Geoghegan 2019-03-28 15:30:15 Re: pgsql: Compute XID horizon for page level index vacuum on primary.
Previous Message Peter Geoghegan 2019-03-28 15:24:46 Re: pgsql: Compute XID horizon for page level index vacuum on primary.

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2019-03-28 15:27:54 Re: monitoring CREATE INDEX [CONCURRENTLY]
Previous Message Peter Geoghegan 2019-03-28 15:24:46 Re: pgsql: Compute XID horizon for page level index vacuum on primary.