| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Gregory Stark <stark(at)mit(dot)edu>, Postgres <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Merge Append Patch merged up to 85devel |
| Date: | 2009-07-07 12:47:49 |
| Message-ID: | 4A5343F5.1020804@sigaev.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Can you provide some more details about the objective of this patch? Or
> a link to previous discussion?
Suppose, Greg's patch could be modified to support order OR index scans:
SELECT ... WHERE (c > 10 AND c < 20) OR (c > 100 AND C < 110) ORDER BY c DESC
with plan:
Result
-> Append
-> Backward index scan (c > 100 AND C < 110)
-> Backward index scan (c > 10 AND C < 20)
I suggested a similar patch two years ago:
http://archives.postgresql.org/message-id/45742C51.9020602@sigaev.ru (4-th
point) and subsequent discussion
http://archives.postgresql.org/pgsql-patches/2006-12/msg00029.php
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2009-07-07 12:52:17 | Re: New types for transparent encryption |
| Previous Message | Fujii Masao | 2009-07-07 11:51:27 | Re: Re: Synch Rep: direct transfer of WAL file from the primary to the standby |