Re: [PATCH] reduce page overlap of GiST indexes built using sorted method - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: [PATCH] reduce page overlap of GiST indexes built using sorted method
Date
Msg-id 6D17898F-7E2D-46DA-BDBF-0A4B5C868B3F@yandex-team.ru
Whole thread Raw
In response to Re: [PATCH] reduce page overlap of GiST indexes built using sorted method  (Björn Harrtell <bjorn.harrtell@gmail.com>)
List 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 by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations
Next
From: Alvaro Herrera
Date:
Subject: Re: Add last commit LSN to pg_last_committed_xact()