Re: [PATCH] reduce page overlap of GiST indexes built using sorted method

Поиск
Список
Период
Сортировка
От Andrey Borodin
Тема Re: [PATCH] reduce page overlap of GiST indexes built using sorted method
Дата
Msg-id 6D17898F-7E2D-46DA-BDBF-0A4B5C868B3F@yandex-team.ru
обсуждение исходный текст
Ответ на Re: [PATCH] reduce page overlap of GiST indexes built using sorted method  (Björn Harrtell <bjorn.harrtell@gmail.com>)
Список pgsql-hackers

> 18 янв. 2022 г., в 03:54, Björn Harrtell <bjorn.harrtell@gmail.com> написал(а):
>
> There might be some deep reason in the architecture that I'm unaware of that could make it difficult to affect the
nodesize but regardless, I believe there could be a substantial win if node size could be controlled. 

That's kind of orthogonal development path. Some years ago I had posted "GiST intrapage indexing" patch [0], that was
aimingto make a tree with fanout that is Sqrt(Items on page). But for now decreasing fillfactor == wasting a lot of
space,both in shared_buffers and on disk... 

Thank you for raising this topic, I think I should rebase and refresh that patch too...

Best regards, Andrey Borodin.


[0] https://www.postgresql.org/message-id/flat/7780A07B-4D04-41E2-B228-166B41D07EEE%40yandex-team.ru


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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Add last commit LSN to pg_last_committed_xact()