Re: Tricky bugs in concurrent index build

Поиск
Список
Период
Сортировка
Искать
От
Zeugswetter Andreas DCP SD
Тема
Re: Tricky bugs in concurrent index build
Дата
Msg-id
E1539E0ED7043848906A8FF995BDA57901410127@m0143.s-mxs.net
Ответ на
Список
Дерево обсуждения
Tricky bugs in concurrent index build Tom Lane <tgl@sss.pgh.pa.us>
Re: Tricky bugs in concurrent index build Greg Stark <gsstark@mit.edu>
Re: Tricky bugs in concurrent index build Greg Stark <gsstark@mit.edu>
Re: Tricky bugs in concurrent index build Tom Lane <tgl@sss.pgh.pa.us>
Re: Tricky bugs in concurrent index build "Joshua D. Drake" <jd@commandprompt.com>
Re: Tricky bugs in concurrent index build Tom Lane <tgl@sss.pgh.pa.us>
Re: Tricky bugs in concurrent index build Hannu Krosing <hannu@skype.net>
Re: Tricky bugs in concurrent index build Hannu Krosing <hannu@skype.net>
Re: Tricky bugs in concurrent index build Greg Stark <gsstark@mit.edu>
Re: Tricky bugs in concurrent index build Tom Lane <tgl@sss.pgh.pa.us>
Re: Tricky bugs in concurrent index build Hannu Krosing <hannu@skype.net>
Re: Tricky bugs in concurrent index build stark <stark@enterprisedb.com>
Re: Tricky bugs in concurrent index build Tom Lane <tgl@sss.pgh.pa.us>
Re: Tricky bugs in concurrent index build stark <stark@enterprisedb.com>
Re: Tricky bugs in concurrent index build Tom Lane <tgl@sss.pgh.pa.us>
Re: Tricky bugs in concurrent index build Gregory Stark <stark@enterprisedb.com>
Re: Tricky bugs in concurrent index build Tom Lane <tgl@sss.pgh.pa.us>
Re: Tricky bugs in concurrent index build Tom Lane <tgl@sss.pgh.pa.us>
Re: Tricky bugs in concurrent index build Gregory Stark <stark@enterprisedb.com>
Re: Tricky bugs in concurrent index build Tom Lane <tgl@sss.pgh.pa.us>
Re: Tricky bugs in concurrent index build Gregory Stark <stark@enterprisedb.com>
Re: Tricky bugs in concurrent index build "Joshua D. Drake" <jd@commandprompt.com>
Re: Tricky bugs in concurrent index build Greg Stark <gsstark@mit.edu>
Re: Tricky bugs in concurrent index build Tom Lane <tgl@sss.pgh.pa.us>
Re: Tricky bugs in concurrent index build "Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at>
Re: Tricky bugs in concurrent index build Greg Stark <gsstark@mit.edu>
Re: Tricky bugs in concurrent index build Tom Lane <tgl@sss.pgh.pa.us>
Re: Tricky bugs in concurrent index build Greg Stark <gsstark@mit.edu>
Re: Tricky bugs in concurrent index build Tom Lane <tgl@sss.pgh.pa.us>

> > Is it not possible to brute force this adding an AM method to insert

> > without the uniqueness check?
> 
> Hm.  Actually there already is a feature of aminsert to allow 
> suppressing the unique check, but I'm not sure whether using 
> it for RECENTLY_DEAD tuples helps.  Seems like we have to 
> wait to see whether DELETE_IN_PROGRESS deleters commit in any case.

Um, but if we wait for the DELETE_IN_PROGRESS tuple, after the wait we
can
add it eighter with or without the unique check (depending on
commit/abort).

Then at least we don't need to wait in a 3rd pass for readers ?

Andreas

В списке pgsql-hackers по дате отправления
От: Karel Zak
Дата:
Сообщение: Re: [PATCHES] COPY view
От: Martijn van Oosterhout
Дата:
FAQ