MIME-Version: 1.0
References: <2023020416592307671913@gmail.com>
In-Reply-To: <2023020416592307671913@gmail.com>
From: Andrey Borodin <amborodin86@gmail.com>
Date: Sat, 4 Feb 2023 12:44:26 -0800
Message-ID: <CAAhFRxjr+3S=tOGBaY5iWCwuMy_w9gtRFHnYiT8hLVp_5oWSqg@mail.gmail.com>
Subject: Re: How to implement read operations for my own access method?
To: "jacktby@gmail.com" <jacktby@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Archived-At: <https://www.postgresql.org/message-id/CAAhFRxjr%2B3S%3DtOGBaY5iWCwuMy_w9gtRFHnYiT8hLVp_5oWSqg%40mail.gmail.com>
Precedence: bulk

On Sat, Feb 4, 2023 at 12:59 AM jacktby@gmail.com <jacktby@gmail.com> wrote:
>
>
> Hi,I'm trying to implement my own access method. But I find the functions baout read is difficult.
> Can you give me an existed easy extension that impelment the tableamroutine to reference? I ho[e
> it's not complicated like heap_am,and it support insert sqls and select sqls.Thanks
>

Hi Jack,

I'd recommend first to start from official documentation on index
access methods [0].
Please also check the contrib/bloom module [1]. It is designed to
showcase index-as-extension technology.
Also, you can see my free lectures about details of implementation of
built-in access methods [2]. Also, I can offer you my PGCon talk
"Index DIY" about forking GiST into extension [3].

Thank you!

Best regards, Andrey Borodin.
[0] https://www.postgresql.org/docs/current/xindex.html
[1] https://github.com/postgres/postgres/tree/REL_15_STABLE/contrib/bloom
[2] https://www.youtube.com/watch?v=UgSeSo973lA&list=PLzrhBdcKTjLTyCIdDO1ig8qCZFZYYi3VH
[3] https://github.com/x4m/index_diy