Re: [DOCS] MVCC snapshot timing

2013-11-11 Thread David Johnston
David Johnston wrote > This reads badly to my ears: >> This means that while querying a database each SQL statement sees a >> snapshot of data (a database version) as it was some time ago, regardless >> of the current state of the underlying data. > How about something closer to: >> This means for

Re: [DOCS] MVCC snapshot timing

2013-11-11 Thread David Johnston
This reads badly to my ears: > This means that while querying a database each SQL statement sees a > snapshot of data (a database version) as it was some time ago, regardless > of the current state of the underlying data. How about something closer to: > This means for each SQL statement the u

Re: [DOCS] MVCC snapshot timing

2013-11-11 Thread Bruce Momjian
On Mon, Nov 11, 2013 at 09:27:15PM -0500, Tom Lane wrote: > Bruce Momjian writes: > > On Mon, Nov 11, 2013 at 08:59:35PM -0500, Tom Lane wrote: > >> 'Statement' might work. > > > OK, updated patch attached. Is "statement" too vague here? SQL > > statement? query? > > "SQL statement" might be

Re: [DOCS] MVCC snapshot timing

2013-11-11 Thread Tom Lane
Bruce Momjian writes: > On Mon, Nov 11, 2013 at 08:59:35PM -0500, Tom Lane wrote: >> 'Statement' might work. > OK, updated patch attached. Is "statement" too vague here? SQL > statement? query? "SQL statement" might be a good idea in the first sentence, but I don't think you need to repeat it

Re: [DOCS] MVCC snapshot timing

2013-11-11 Thread Bruce Momjian
On Mon, Nov 11, 2013 at 08:59:35PM -0500, Tom Lane wrote: > Bruce Momjian writes: > > On Mon, Nov 11, 2013 at 03:39:45PM -0500, Tom Lane wrote: > >> I'm not really seeing the point of s/transaction/session/ here. > > > Well, the problem with the original wording is that we don't take a new > > sn

Re: [DOCS] MVCC snapshot timing

2013-11-11 Thread Tom Lane
Bruce Momjian writes: > On Mon, Nov 11, 2013 at 03:39:45PM -0500, Tom Lane wrote: >> I'm not really seeing the point of s/transaction/session/ here. > 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. We

Re: [DOCS] MVCC snapshot timing

2013-11-11 Thread Bruce Momjian
On Mon, Nov 11, 2013 at 03:39:45PM -0500, Tom Lane wrote: > Bruce Momjian 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 > > snapsh

Re: [DOCS] MVCC snapshot timing

2013-11-11 Thread Tom Lane
Bruce Momjian 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 >

[DOCS] MVCC snapshot timing

2013-11-11 Thread Bruce Momjian
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 wan

Re: [DOCS] manpage enhancement in 9.3.1 on Linux

2013-11-11 Thread Josh Kupershmidt
On Sat, Nov 9, 2013 at 1:49 PM, Karl-Philipp Richter wrote: > I'm new to this list an hope to be in the right place to request a > documentation enhancement in the Linux manpage of pg_createcluster. I believe pg_createcluster is a Debian/Ubuntu-specific package, i.e. not something created or mai