Re: Rewrite, normal execution vs. EXPLAIN ANALYZE
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>, David Fetter <david@fetter.org>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2010-07-23T22:43:34Z
Lists: pgsql-hackers
On Fri, Jul 23, 2010 at 6:20 PM, Alvaro Herrera <alvherre@commandprompt.com> wrote: > Excerpts from Marko Tiikkaja's message of vie jul 23 17:44:21 -0400 2010: >> On 7/24/10 12:37 AM +0300, Alvaro Herrera wrote: >> > Excerpts from Marko Tiikkaja's message of vie jul 23 14:13:18 -0400 2010: > >> > I don't think it's fair game to change the behavior of multiple-output >> > rules at this point. However, I also think that it's unwise to base >> > wCTEs on the behavior of rules -- rules are widely considered broken and >> > unusable for nontrivial cases. >> >> I don't want to change the behaviour either, but we have two different >> behaviours right now. We need to change at least the other. > > It seems like it's EXPLAIN ANALYZE that needs fixing. I would suggest that if we're going to change this, we back-patch it to 9.0 before beta4. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company