Re: pgsql: Improve gist XLOG code to follow the coding

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pgsql: Improve gist XLOG code to follow the coding
Дата
Msg-id 7342.1144071434@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pgsql: Improve gist XLOG code to follow the coding  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: pgsql: Improve gist XLOG code to follow the coding  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-committers
>> Hmm.  That probably needs to be redesigned then.

> Don't understand. Root will be fully regenerated and filled with invalid tuples.

Well, ISTM that if complete replay of the WAL sequence yields an invalid
index, then you've not got an adequate design for the WAL data.  Special
recovery actions really should only be needed if the WAL log is
incomplete (ie, it ends in the middle of a page-split sequence).

> I see, there is a problem with gistSplit: it can generate more than 3 pages
> (three - is a limit of XLogInsert) in a case of bad user's picksplit method...

I think we are OK on that, actually, because the page-split WAL record
is designed to rewrite all of the pages completely.  Only pages that are
going to be incrementally updated need to be exposed to XLogInsert.
So the root-page case in page-update is the only one that seems inadequate.

            regards, tom lane

В списке pgsql-committers по дате отправления:

Предыдущее
От: teodor@postgresql.org (Teodor Sigaev)
Дата:
Сообщение: pgsql: Detoast query in g_intbig_consistent and copy query in
Следующее
От: teodor@postgresql.org (Teodor Sigaev)
Дата:
Сообщение: pgsql: Eliminate ajust scan code.