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

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: pgsql: Make heap TID a tiebreaker nbtree index column.
Дата
Msg-id CAH2-Wz=wyWw+wwQEKJdx-DpWbnu+Hsfd1=mxnBMtYJnWEYSJaQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgsql: Make heap TID a tiebreaker nbtree index column.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pgsql: Make heap TID a tiebreaker nbtree index column.
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: pgsql: Make heap TID a tiebreaker nbtree index column.