Re: How to share the result data of separated plan - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: How to share the result data of separated plan
Date
Msg-id 4CD87BD7.6040009@cs.helsinki.fi
Whole thread Raw
In response to Re: How to share the result data of separated plan  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2010-11-08 8:30 PM +0200, Tom Lane wrote:
> Marko Tiikkaja<marko.tiikkaja@cs.helsinki.fi>  writes:
>> On 2010-11-08 7:26 PM +0200, Tom Lane wrote:
>>> The alternative is to artificially serialize the DML CTEs, which
>>> while it does have some advantages doesn't seem like a win overall.
>
>> We've discussed this before and the consensus was that as long as we
>> don't change the results, we can optimize the materialization away.
>
> No, because the problem is mainly about what might happen if
> user-defined functions choose to look at the target tables.  We can't
> really tell what triggers are going to do, to take one item that the
> planner has no access to.

The relevant thread seems to be this one:

http://archives.postgresql.org/pgsql-hackers/2009-11/msg00003.php

and I do agree with what you said there.


Regards,
Marko Tiikkaja


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: W3C Specs: Web SQL
Next
From: Josh Berkus
Date:
Subject: Re: How can we tell how far behind the standby is?