Re: GiST VACUUM

Поиск
Список
Период
Сортировка
Искать
От
Andrey Borodin
Тема
Re: GiST VACUUM
Дата
Msg-id
349EC5CE-8D46-41EB-A440-A16403EE3184@yandex-team.ru
Ответ на
Re: GiST VACUUM (Heikki Linnakangas)
Список
Дерево обсуждения
GiST VACUUM Andrey Borodin <x4mmm@yandex-team.ru>
Re: GiST VACUUM Thomas Munro <thomas.munro@enterprisedb.com>
Re: GiST VACUUM Andrey Borodin <x4mmm@yandex-team.ru>
Re: GiST VACUUM Heikki Linnakangas <hlinnaka@iki.fi>
Re: GiST VACUUM Andrey Borodin <x4mmm@yandex-team.ru>
Re: GiST VACUUM Heikki Linnakangas <hlinnaka@iki.fi>
Re: GiST VACUUM Andrey Borodin <x4mmm@yandex-team.ru>
Re: GiST VACUUM Andrey Borodin <x4mmm@yandex-team.ru>


> 22 марта 2019 г., в 19:37, Heikki Linnakangas  написал(а):
> 
> On 21/03/2019 19:04, Heikki Linnakangas wrote:
>> Attached is the latest patch version, to be applied on top of the
>> IntegerSet patch.
> 
> And committed. Thanks Andrey!
> 
> - Heikki

Cool! Thank you very much! At the beginning I could not image how many caveats are there.

> 22 марта 2019 г., в 18:28, Heikki Linnakangas  написал(а):
> 
> * Currently, a search needs to scan all items on a page. If the keys are small, that can be pretty slow. Divide each page further into e.g. 4 sub-pages, with a "bounding box" key for each sub-page, to speed up search.
BTW, I already have intra-page indexing patch. But now it obviously need a rebase :) Along with gist amcheck patch.

Thanks!

Best regards, Andrey Borodin.
В списке pgsql-hackers по дате отправления
От: Peter Eisentraut
Дата:
Сообщение: Re: insensitive collations
От: Jesper Pedersen
Дата:
FAQ