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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
