Re: Rewrite, normal execution vs. EXPLAIN ANALYZE

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>, David Fetter <david(at)fetter(dot)org>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Rewrite, normal execution vs. EXPLAIN ANALYZE
Date: 2010-07-23 22:43:34
Message-ID: AANLkTi=wADn4rToSqnMmOBZ8L_Z15iqPgha4kymJZ6zK@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jul 23, 2010 at 6:20 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2010-07-23 22:45:15 Re: Rewrite, normal execution vs. EXPLAIN ANALYZE
Previous Message Marko Tiikkaja 2010-07-23 22:42:59 Re: Rewrite, normal execution vs. EXPLAIN ANALYZE