Re: Rewrite, normal execution vs. EXPLAIN ANALYZE

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Marko Tiikkaja" <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
Cc: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "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:45:15
Message-ID: 4C49D52B0200002500033C3A@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Yeb Havinga 2010-07-24 06:56:18 Review of Synchronous Replication patches
Previous Message Robert Haas 2010-07-23 22:43:34 Re: Rewrite, normal execution vs. EXPLAIN ANALYZE