Re: comparing index columns - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: comparing index columns
Date
Msg-id 466FBEB9.7090505@enterprisedb.com
Whole thread Raw
In response to Re: comparing index columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: comparing index columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> "Pavan Deolasee" <pavan.deolasee@gmail.com> writes:
>> I don't have much insight into the operator classes and operator families
>> and how they work. Where should I look for the related code ?
> 
> Primary opclass members are stored right in the Relation data struct for
> you.  Since (I trust) you're only supporting this for btree, you could
> just use rd_supportinfo[0] which will not even cost an fmgr lookup.
> See index_getprocinfo() and callers.

There's currently no reason to limit HOT to b-trees.

How about just doing a memcmp? That would be safe, simple and fast and 
covers all interesting use cases.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Selecting a constant question: A summary
Next
From: "Zeugswetter Andreas ADI SD"
Date:
Subject: Re: Selecting a constant question: A summary