public inbox for [email protected]  

help / color / mirror / Atom feed

From: Emre Hasegeli <[email protected]>
To: Peter Eisentraut <[email protected]>
Cc: pgsql-hackers <[email protected]>
Subject: Re: btree_gist into core?
Date: Thu, 14 Dec 2023 12:35:17 +0100
Message-ID: <CAE2gYzw=g5Cfyuo_jkhMey8jDFTxDyV3CNRp6eS8EHXYBajQLA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

> 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.

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: btree_gist into core?
  In-Reply-To: <CAE2gYzw=g5Cfyuo_jkhMey8jDFTxDyV3CNRp6eS8EHXYBajQLA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox