Re: [Proposal] Improvement of GiST page layout

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: amborodin(at)acm(dot)org
Cc: aekorotkov(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [Proposal] Improvement of GiST page layout
Date: 2026-02-09 02:44:50
Message-ID: 8888910E-4B2A-4A5B-A70B-F9476FB75E21@yandex-team.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 9 Feb 2016, at 10:15, Andrew Borodin <borodin(at)octonica(dot)com> wrote:
>
> Hi, hackers!
>
> I want to propose improvement of GiST page layout.
>
> GiST is optimized to reduce disk operations on search queries, for
> example, windows search queries in case of R-tree.
>
> I expect that more complicated page layout will help to tradeoff some
> of CPU efficiency for disk efficiency.

Sorry for bumping old thread. And thanks to Hackorum, I now know this thread started exactly 10 years ago. After several patch attempts, it's still on my TODO list :)

That quoted message was the best career choice I ever made. I can't imagine a more rewarding job than working on Postgres. But it's not just about a career - I entered a community.

Just look at this! 10 years ago, after attending an inspiring conference, I posted a proposal to pgsql-hackers and boarded a plane home. Upon landing, I had a response in my inbox. A response from one of the most knowledgeable experts in the field! Several hours later, I was invited back to the conference to discuss the proposal with other experts.

If anyone reading this is considering hacking on Postgres: if I weren't already doing what I do, I'd advise my past self to start right now. It might seem that data management is a solved problem. Yes, Postgres is a mature database. But even after several decades, it's being developed rapidly, the community grows day by day, and we face new challenges constantly.

Thanks to everyone here who helped me learn. I'm very grateful for your expertise and patience. I know there's still a lot to learn, to study, to invent, to design, to build, to fix, and to hack on.

P.S. That GiST page layout? Ofc I will return to the idea. Eventually. But if anyone want to work on this - I'd be happy to collab.

Best regards, Andrey Borodin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Karlsson 2026-02-09 03:06:35 Re: get rid of Pointer type, mostly
Previous Message Hayato Kuroda (Fujitsu) 2026-02-09 02:38:23 RE: BUG: Former primary node might stuck when started as a standby