Re: comparing index columns

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: comparing index columns
Дата
Msg-id 466FBEB9.7090505@enterprisedb.com
обсуждение исходный текст
Ответ на Re: comparing index columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: comparing index columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: Selecting a constant question: A summary
Следующее
От: "Zeugswetter Andreas ADI SD"
Дата:
Сообщение: Re: Selecting a constant question: A summary