Re: btree_gist into core? - Mailing list pgsql-hackers

From Emre Hasegeli
Subject Re: btree_gist into core?
Date
Msg-id CAE2gYzw=g5Cfyuo_jkhMey8jDFTxDyV3CNRp6eS8EHXYBajQLA@mail.gmail.com
Whole thread Raw
In response to btree_gist into core?  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-hackers
> Thoughts?

I think it'd be really nice to do this without btree_gist.

I imagine something like this:

CREATE INDEX ON tbl USING gist (
    range_col,
    int_col USING btree
)

I think this would make the index access methods interface more
useful.  Index access method developers wouldn't need to provide
operator classes for all data types.  We could extend ACCESS METHOD
definition to allow this:

CREATE ACCESS METHOD my_hash_index
    TYPE INDEX
    IMPLEMENTS hash
    HANDLER my_hash_index_handler

I realise this is a difficult project.



pgsql-hackers by date:

Previous
From: tender wang
Date:
Subject: Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock
Next
From: "Andrey M. Borodin"
Date:
Subject: Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock