Re: POC, WIP: OR-clause support for indexes - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: POC, WIP: OR-clause support for indexes
Date
Msg-id 567EE99F.8040607@sigaev.ru
Whole thread Raw
In response to Re: POC, WIP: OR-clause support for indexes  (Feng Tian <ftian@vitessedata.com>)
List pgsql-hackers
> This is great.   I got a question, is it possible make btree index to support OR
> as well?  Is btree supports more invasive, in the sense that we need to do
> enhance ScanKey to supports an array of values?
Btree now works by follow: find the max/min tuple which satisfies condtions and 
then executes forward/backward scan over leaf pages. For complicated clauses 
it's not obvious how to find min/max tuple. Scanning whole index isn't an option 
from preformance point of view.

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/
 



pgsql-hackers by date:

Previous
From: Feng Tian
Date:
Subject: Re: POC, WIP: OR-clause support for indexes
Next
From: Joe Conway
Date:
Subject: Re: exposing pg_controldata and pg_config as functions