| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Markus Schiltknecht" <markus(at)bluegap(dot)ch> |
| Cc: | "Gregory Stark" <stark(at)enterprisedb(dot)com>, "NikhilS" <nikkhils(at)gmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Auto Partitioning |
| Date: | 2007-04-04 19:01:45 |
| Message-ID: | 1175713305.3623.197.camel@silverbirch.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
On Wed, 2007-04-04 at 20:55 +0200, Markus Schiltknecht wrote:
> Questioning the other way around: do we need any sort of multi-table
> indexes at all, or isn't it enough to teach the planner and executor how
> to intelligently scan through (possibly) multiple indexes to get what is
> requested?
No, I don't think we need multi-table indexes at all.
The planner already uses the Append node to put together multiple plans.
The great thing is it will put together IndexScans and SeqScans as
applicable. No need for multi-scans as a special node type.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-04 19:01:59 | Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch |
| Previous Message | Zoltan Boszormenyi | 2007-04-04 18:57:02 | Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-04 19:01:59 | Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch |
| Previous Message | Zoltan Boszormenyi | 2007-04-04 18:57:02 | Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch |