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 7069.1321203142@sss.pgh.pa.us
Whole thread Raw
In response to Re: why do we need two snapshots per query?  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> It's all very well to refuse individual cases where linkage is
> required, but ISTM clear that there are many possible uses of being
> able to tell whether a plan is one-shot or not and nothing lost by
> allowing that information (a boolean) pass to the executor.

It's an interconnection between major modules that IMO we don't need.
Having the executor behave differently depending on the planning path
the query took creates complexity, which creates bugs.  You haven't
produced any use-case at all that convinces me that it's worth the risk;
nor do I believe there are lots more use-cases right around the corner.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Detach/attach database
Next
From: Andres Freund
Date:
Subject: Re: Detach/attach database