public inbox for [email protected]  

help / color / mirror / Atom feed

From: Robert Haas <[email protected]>
To: [email protected] <[email protected]>
Subject: can system catalogs have GIN indexes?
Date: Thu, 27 Apr 2023 14:03:54 -0400
Message-ID: <CA+TgmoYWyOWLDXi=-8qpD3h06GcyjJqPAv9279edfzag6jDH=w@mail.gmail.com> (raw)

Hi,

Today, I found myself wondering whether we could add a non-btree
index, and in particular a GIN index, to a system catalog if we so
desired. Currently, after initdb, we only create tables and btree
indexes, but I'm not sure if there is any good reason why we couldn't
do something else. One problem with a GIN index specifically is that
it doesn't implement amgettuple, so routines like systable_getnext()
and index_getnext() couldn't be used, and we'd have to code up a
bitmap scan. Currently, bitmap scans aren't used anywhere other than
the executor, but I don't know of any reason why it wouldn't be
practical to use them elsewhere.

I think I may pursue a different approach to the problem that led me
to think about this, at least for the moment. But I'm still curious
about the general question: if somebody showed up with a well-written
patch that added a GIN index to a system catalog, would that
potentially be acceptable, or DOA?

-- 
Robert Haas
EDB: http://www.enterprisedb.com

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]
  Subject: Re: can system catalogs have GIN indexes?
  In-Reply-To: <CA+TgmoYWyOWLDXi=-8qpD3h06GcyjJqPAv9279edfzag6jDH=w@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