Re: why do we need two snapshots per query? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: why do we need two snapshots per query?
Date
Msg-id 4811.1321023694@sss.pgh.pa.us
Whole thread Raw
In response to why do we need two snapshots per query?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: why do we need two snapshots per query?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> Can't we arrange to retain the snapshot used for parse
> analysis / planning and reuse it for the portal that we create just
> afterwards?

Possibly, but what if planning takes a long time?  Also, I think you're
ignoring the extended-query-protocol scenario, where it would be a whole
lot harder to justify keeping a snapshot from Parse through Bind and
Execute.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Manual anti-wraparound vacuums
Next
From: Andreas 'ads' Scherbaum
Date:
Subject: Hotel reservation for FOSDEM 2012 - Deadline: December 31th, 2011