Re: Extending opfamilies for GIN indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Extending opfamilies for GIN indexes
Date
Msg-id 21850.1295458157@sss.pgh.pa.us
Whole thread Raw
In response to Re: Extending opfamilies for GIN indexes  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: Extending opfamilies for GIN indexes  (Robert Haas <robertmhaas@gmail.com>)
Re: Extending opfamilies for GIN indexes  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-hackers
Dimitri Fontaine <dimitri@2ndQuadrant.fr> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> Oh, wait a minute: there's a bad restriction there, namely that a
>> contrib module could only add "loose" operators that had different
>> declared input types from the ones known to the core opclass.

> I would have though that such contrib would then need to offer their own
> opfamily and opclasses, and users would have to use the specific opclass
> manually like they do e.g. for text_pattern_ops.  Can't it work that way?

I think you missed the point: right now, to use both the core and
intarray operators on an integer[] column, you have to create *two*
GIN indexes, which will have exactly identical contents.  I'm looking
for a way to let intarray extend the core opfamily definition so that
one index can serve.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: limiting hint bit I/O
Next
From: Robert Haas
Date:
Subject: Re: Re: patch: fix performance problems with repated decomprimation of varlena values in plpgsql