Re: Own index methods

2020-05-06 Thread Michael Paquier
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


signature.asc
Description: PGP signature


Re: Own index methods

2020-05-06 Thread Alexander Korotkov
On Tue, May 5, 2020 at 5:10 PM Tom Lane  wrote:
>
> Benjamin Schaller  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




Re: Own index methods

2020-05-06 Thread Andrey M. Borodin
Hi!

> 5 мая 2020 г., в 17:21, Benjamin Schaller 
>  написал(а):
> 
> 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?

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

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

Best regards, Andrey Borodin.



Re: Own index methods

2020-05-05 Thread Tom Lane
Benjamin Schaller  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




Own index methods

2020-05-05 Thread Benjamin Schaller

Hi,

in the Postgres documentation it says: "PostgreSQLprovides 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