Re: amcheck verification for GiST

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: amcheck verification for GiST
Дата
Msg-id ce71440c-a481-d0d7-b9de-61cd78dad77c@iki.fi
обсуждение исходный текст
Ответ на Re: amcheck verification for GiST  (Andrey Borodin <x4mmm@yandex-team.ru>)
Ответы Re: amcheck verification for GiST
Список pgsql-hackers
There's a little copy-pasto in gist_check_page_keys():

> +            for (o = FirstOffsetNumber; o <= parent_maxoff; o = OffsetNumberNext(i))

Should be "OffsetNumberNext(o)".

I tested this patch with your testing patch from the other thread (after 
fixing the above), to leave behind incompletely split pages [1]. It 
seems that the amcheck code doesn't expect incomplete splits:

postgres=# SELECT gist_index_parent_check('x_c_idx');
ERROR:  index "x_c_idx" has inconsistent records

[1] 
https://www.postgresql.org/message-id/EB87A69B-EE5E-4259-9EEB-DA9DC1F7E265%40yandex-team.ru

- Heikki


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

Предыдущее
От: "Imai, Yoshikazu"
Дата:
Сообщение: RE: speeding up planning with partitions
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: GiST VACUUM