Обсуждение: 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