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

From Peter Geoghegan
Subject Re: pgsql: Make heap TID a tiebreaker nbtree index column.
Date
Msg-id CAH2-Wz=wyWw+wwQEKJdx-DpWbnu+Hsfd1=mxnBMtYJnWEYSJaQ@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Make heap TID a tiebreaker nbtree index column.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
On Fri, Mar 22, 2019 at 9:32 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Apparently, that case is indeed unstable, cf
>
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fulmar&dt=2019-03-22%2016%3A15%3A14

I had a feeling that that would happen.

> I'm fairly baffled as to why the output order would be unstable
> given the sort, and even more as to why the instability didn't
> emerge before.  Any thoughts?

 DROP ROLE seems to be where all the remaining problems were, and the
order in the regression tests didn't change back to the old order when
you pushed the change to DROP OWNED BY. Something seemed amiss to me
for these reasons.

-- 
Peter Geoghegan


pgsql-committers by date:

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