Horton

Re: Rewrite, normal execution vs. EXPLAIN ANALYZE

Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>

View thread
From: Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Alvaro Herrera <alvherre@commandprompt.com>, David Fetter <david@fetter.org>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2010-07-23T21:48:25Z
Lists: pgsql-hackers 
On 7/24/10 12:42 AM +0300, Kevin Grittner wrote:
> Alvaro Herrera<alvherre@commandprompt.com>  wrote:
>
>> In short I think a wCTE should only advance the CID, not get a
>> whole new snapshot.
>
> Even after unblocking from a write conflict at the READ COMMITTED
> isolation level?

I'm not sure what you mean by this; UPDATE and DELETE can take a look at 
the new tuple but that's completely separate from the snapshot.



Regards,
Marko Tiikkaja