From: Josh Berkus <josh@agliodbs.com>
To: JOE <joe@piscitella.com>
To: pgsql-sql@postgresql.org
Subject: Re: union optimization in views
Date: Thu, 29 Aug 2002 10:52:39 -0700
Message-ID: <200208291052.39160.josh@agliodbs.com> (raw)
In-Reply-To: <003d01c24f17$2d21ff00$c801a8c0@joe>
References: <003d01c24f17$2d21ff00$c801a8c0@joe>
Joe,
> We are attempting to move a couple of systems from Oracle to Postgres but
can not do so without application rewrites due to the current use of views
with UNIONs and the criticality of the performances of these views.
>
> I was wondering if a decision has been made on the optimization with the
UNION clause in views. There are many documents in the SQL archive showing
that the "push down" is not occuring and thus the use of UNION's in views is
limited to case where the data set is small or performance is not a
consideration. I also looked through the TODO list and didn't see anything
(of course I could have missed references).
I'd take this up on PGSQL-HACKERS. The UNION VIEW optimization, last I
checked, was stalled mainly because nobody wanted to work on it. Maybe you
can?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, joe@piscitella.com
Subject: Re: union optimization in views
In-Reply-To: <200208291052.39160.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox