From 8b109ebf14cf449d36f293a4cb8188360fd5aec6 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 3 Feb 2006 21:08:49 +0000 Subject: Teach planner to convert simple UNION ALL subqueries into append relations, thereby sharing code with the inheritance case. This puts the UNION-ALL-view approach to partitioned tables on par with inheritance, so far as constraint exclusion is concerned: it works either way. (Still need to update the docs to say so.) The definition of "simple UNION ALL" is a little simpler than I would like --- basically the union arms can only be SELECT * FROM foo --- but it's good enough for partitioned-table cases. --- src/backend/optimizer/plan/planner.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/backend/optimizer/plan/planner.c') diff --git a/src/backend/optimizer/plan/planner.c b/src/backend/optimizer/plan/planner.c index e007e4e594e..e530a1ac6eb 100644 --- a/src/backend/optimizer/plan/planner.c +++ b/src/backend/optimizer/plan/planner.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/optimizer/plan/planner.c,v 1.197 2006/01/31 21:39:24 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/optimizer/plan/planner.c,v 1.198 2006/02/03 21:08:49 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -222,7 +222,7 @@ subquery_planner(Query *parse, double tuple_fraction, * this query. */ parse->jointree = (FromExpr *) - pull_up_subqueries(root, (Node *) parse->jointree, false); + pull_up_subqueries(root, (Node *) parse->jointree, false, false); /* * Detect whether any rangetable entries are RTE_JOIN kind; if not, we can -- cgit v1.2.3