Re: Design notes for EquivalenceClasses - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: Design notes for EquivalenceClasses
Date
Msg-id 45AFAD57.9050203@sigaev.ru
Whole thread Raw
In response to Re: Design notes for EquivalenceClasses  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>>> Note that a bitmap scan or multi-pass indexscan (OR clause scan) has NIL
>>> pathkeys since we can say nothing about the overall order of its result.
> Yeah, but it might come back someday, so I didn't feel a need to change
> that sentence...

Hmm. Our OR patch makes the same possibility by using Append node - without
reintroducing multi-pass indexscan. Moreover, it allows to sort OR clauses to 
match sort order.

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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Corrupt database? 8.1/FreeBSD6.0
Next
From: "Adnan DURSUN"
Date:
Subject: Re: Temparary disable constraint