Re: pgsql: Make heap TID a tiebreaker nbtree index column.
От
Tom Lane
Тема
Re: pgsql: Make heap TID a tiebreaker nbtree index column.
Дата
Msg-id
24277.1553114810@sss.pgh.pa.us
Ответ на
Re: pgsql: Make heap TID a tiebreaker nbtree index column. (Peter Geoghegan)
Список
Дерево обсуждения
pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Tom Lane <tgl@sss.pgh.pa.us>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Andres Freund <andres@anarazel.de>
Re: pgsql: Make heap TID a tiebreaker nbtree index column. Peter Geoghegan <pg@bowt.ie>
Peter Geoghegan writes: > On Wed, Mar 20, 2019 at 11:30 AM Peter Geoghegan wrote: >> Your work on test stability probably eliminated 98% of the problems. >> It's still early, but the buildfarm is mostly fine. > batfish just had a similar failure, this time in foreign_data -- two > lines of "DETAIL" output appear in opposite-of-expected order. > Obviously that's unstable in a way that it wasn't before now, since > every other animal doesn't have that problem. Yeah. My opinion is that we should just qsort the list of targets during DROP OWNED and be done with this. I'll post a patch shortly. In the meantime, would you mind cleaning this up: nbtxlog.c: In function 'btree_xlog_split': nbtxlog.c:269: warning: 'newitem' may be used uninitialized in this function nbtxlog.c:269: note: 'newitem' was declared here nbtxlog.c:271: warning: 'newitemsz' may be used uninitialized in this function nbtxlog.c:271: note: 'newitemsz' was declared here regards, tom lane
В списке pgsql-committers по дате отправления
От: Peter Geoghegan
Дата:
От: Peter Geoghegan
Дата: