[PATCH] sort leaf pages by ctid for gist indexes built using sorted method

Поиск
Список
Период
Сортировка
От Aliaksandr Kalenik
Тема [PATCH] sort leaf pages by ctid for gist indexes built using sorted method
Дата
Msg-id CAHqSB9gd0NnQuPHSnnR7BC-rNnJWZ53rRA+vYZF4pcRK-4y_kw@mail.gmail.com
обсуждение исходный текст
Ответы Re: [PATCH] sort leaf pages by ctid for gist indexes built using sorted method  (Andrey Borodin <x4mmm@yandex-team.ru>)
Список pgsql-hackers
Hi!

With the current implementation, for GiST indexes created by doing multiple inserts, index tuples match heap tuples order, but it doesn't work that way for sorted method where index tuples on all levels are ordered using comparator provided in sortsupport (z-order for geometry type, for example). This means two tuples that are on the same heap page can be far apart from one another on an index page, and the heap page may be read twice and prefetch performance will degrade.

I've created a patch intended to improve that by sorting index tuples by heap tuples TID order on leaf pages.
Вложения

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Adding CI to our tree
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: Skipping logical replication transactions on subscriber side