Re: Index AM change proposals, redux

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Index AM change proposals, redux
Date: 2008-04-10 17:48:14
Message-ID: 5584.1207849694@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Teodor Sigaev <teodor(at)sigaev(dot)ru> writes:
> Both GIN and GiST make a call of transformation function before indexing value.
> I suppose, there is no automatic way to set this flag even in case when type of
> storage and type of indexing value are the same.

> So, I see three variant:
> - add flag in pg_am
> - add flag to create operator class and by default it should point to
> impossibility to get value from index. At least for GIN and GiST.

Yeah, just as messy as I feared :-(. My inclination for the first pass
would be to just make it a per-AM flag in pg_am. We could always
complicate matters later.

(Of course, this is all hypothetical since no patch is on the
horizon...)

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2008-04-10 18:01:47 Re: Index AM change proposals, redux
Previous Message Alvaro Herrera 2008-04-10 17:48:09 Re: Kludge in pg_standby.c