Re: Design notes for EquivalenceClasses

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Design notes for EquivalenceClasses
Date: 2007-01-18 17:24:39
Message-ID: 45AFAD57.9050203@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Adnan DURSUN 2007-01-18 22:09:17 Re: Temparary disable constraint
Previous Message Tom Lane 2007-01-18 16:52:23 Re: Corrupt database? 8.1/FreeBSD6.0