Re: MVCC snapshot timing

On Mon, Nov 11, 2013 at 03:39:45PM -0500, Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > I received a private email report that our introductory MVCC
> > documentation is unclear about when a snapshot is taken. I have
> > adjusted the wording in the attached patch to be less precise about
> > snapshot timing. Snapshot timing is controlled by the session isolation
> > level, which I don't think we want to cover in this introductory
> > paragraph.
>
> I'm not really seeing the point of s/transaction/session/ here.
> The phrasing is a bit awkward and maybe could be improved, but I think you
> should keep it referring to transactions.

Well, the problem with the original wording is that we don't take a new
snapshot for every transaction in the default read-committed mode.
Would you prefer I refer to statements, e.g.:

This means that while querying a database each statement sees

This is our default behavior.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +