Обсуждение: Own index methods

Hi,

in the Postgres documentation it says: "PostgreSQL provides the index methods B-tree, hash, GiST, SP-GiST, GIN, and BRIN. Users can also define their own index methods, but that is fairly complicated." (https://www.postgresql.org/docs/12/sql-createindex.html)

Even though it's described as fairly complicated: If I would want to define my own index method, what would be a good approach to do so?

Best regards

Benjamin Schaller <benjamin.schaller@s2018.tu-chemnitz.de> writes:
> Even though it's described as fairly complicated: If I would want to 
> define my own index method, what would be a good approach to do so?

contrib/bloom would make a sensible template, perhaps.

            regards, tom lane

Hi!

> 5 мая 2020 г., в 17:21, Benjamin Schaller <benjamin.schaller@s2018.tu-chemnitz.de> написал(а):
>
> Even though it's described as fairly complicated: If I would want to define my own index method, what would be a good
approachto do so? 

I'm working on presentation describing how to fork AM out of core to extension. Hope to be available soon. I'll send
youa link when it's available. 

This small code copy-pasting helps to narrow focus (postgres codebase is big), makes experiments with new not yet
committedfeatures easier and allows to "specialise" generic indexes more precisely. 

Best regards, Andrey Borodin.

On Tue, May 5, 2020 at 5:10 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Benjamin Schaller <benjamin.schaller@s2018.tu-chemnitz.de> writes:
> > Even though it's described as fairly complicated: If I would want to
> > define my own index method, what would be a good approach to do so?
>
> contrib/bloom would make a sensible template, perhaps.

+1

You can also take a look at https://github.com/postgrespro/rum

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

On Wed, May 06, 2020 at 11:14:49AM +0300, Alexander Korotkov wrote:
> You can also take a look at https://github.com/postgrespro/rum

Please note that we have also an extra, mostly-blank, template as of
src/test/modules/dummy_index_am/ which has been added in v13 for
mainly testing purposes, but you can use it as a base for any new
stuff you are willing to try.
--
Michael