Re: pgsql: Make heap TID a tiebreaker nbtree index column. - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Make heap TID a tiebreaker nbtree index column.
Date
Msg-id 13999.1553105283@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: Make heap TID a tiebreaker nbtree index column.  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: pgsql: Make heap TID a tiebreaker nbtree index column.
List pgsql-committers
Peter Geoghegan <pg@bowt.ie> writes:
> On Wed, Mar 20, 2019 at 10:05 AM Peter Geoghegan <pg@bowt.ie> wrote:
>> Make heap TID a tiebreaker nbtree index column.

> I see that this has caused SELinux test failures on rhinoceros (the
> ddl test fails). It looks like the output order is affected by the
> implementation details of nbtree, likely for some system catalog
> index. This is something that I've had to deal with in other places
> (with a lot of help from Tom).

The diffs all are related to the order of operations in a DROP OWNED BY
command, so I think blaming SELinux is just blaming the messenger.
This comes down to the point that we didn't do anything to ensure
drop order stability in shdepend-driven drops.  Maybe we need to be
honest about that.  Or do you have reason to think that your changes
will result in stability in that drop order anyway?  If so, why?

            regards, tom lane


pgsql-committers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: pgsql: Make heap TID a tiebreaker nbtree index column.
Next
From: Andres Freund
Date:
Subject: Re: pgsql: Make heap TID a tiebreaker nbtree index column.