Horton

Re: Rewrite, normal execution vs. EXPLAIN ANALYZE

Kevin Grittner <kevin.grittner@wicourts.gov>

View thread
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Marko Tiikkaja" <marko.tiikkaja@cs.helsinki.fi>
Cc: "Alvaro Herrera" <alvherre@commandprompt.com>, "David Fetter" <david@fetter.org>, "pgsql-hackers" <pgsql-hackers@postgresql.org>
Date: 2010-07-23T22:45:15Z
Lists: pgsql-hackers 
Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi> wrote:
 
> 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.
 
Never mind -- I remembered that those could operate against tuples
not in the original snapshot, but forgot that they did it without
generating an actual fresh snapshot.
 
-Kevin