Re: pgsql: Make heap TID a tiebreaker nbtree index column.

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-committers <pgsql-committers(at)lists(dot)postgresql(dot)org>
Subject: Re: pgsql: Make heap TID a tiebreaker nbtree index column.
Date: 2019-03-20 21:47:58
Message-ID: CAH2-WzmfxXs3bSX6T3DP1wTEWbyhkTiyPZ6o9t2DmcHbBtsCNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

On Wed, Mar 20, 2019 at 2:44 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> After trying it (against yesterday's sources) on my SELinux-capable
> machine, I see no evidence that we need any output ordering changes
> at all if we go this route. This is probably unsurprising considering
> that the old btree code used to provide mostly-reverse-insertion-order
> scan order.

That's good. I'm trying to fix it by hand right now, in the way that
Andres suggested. It is both tedious and error-prone.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2019-03-20 21:50:45 Re: pgsql: Make heap TID a tiebreaker nbtree index column.
Previous Message Tom Lane 2019-03-20 21:44:15 Re: pgsql: Make heap TID a tiebreaker nbtree index column.