On Tue, Nov 20, 2012 at 9:10 AM, Claudio Freire <[email protected]> wrote: > On Tue, Nov 20, 2012 at 12:04 PM, Merlin Moncure <[email protected]> wrote: >> The problem here is very clear. Oracle is optimizing through the CTE. >> PostgreSQL does not do this by design -- CTE's are used as a forced >> materialization step. > > While I love that design (it lets me solve lots of problems for huge > queries), wouldn't pushing constraints into the CTE be a rather safe > optimization?
sure, or rewrite query as classic join. merlin -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
