Re: MVCC snapshot timing - Mailing list pgsql-docs

From David Johnston
Subject Re: MVCC snapshot timing
Date
Msg-id 1384306523691-5778033.post@n5.nabble.com
Whole thread Raw
In response to Re: MVCC snapshot timing  (Bruce Momjian <bruce@momjian.us>)
Responses Re: MVCC snapshot timing  (Bruce Momjian <bruce@momjian.us>)
List pgsql-docs
Bruce Momjian wrote
> On Tue, Nov 12, 2013 at 03:36:01PM -0800, David Johnston wrote:
>> Bruce Momjian wrote
>> > We just want to get across the MVCC concept in the intro --- we cover
>> > the snapshots later in the document.
>>
>> I just think we're being too vague here; and we are covering them in the
>> intro with the use of "some point in the past".
>>
>> IMO, the main point regarding MVCC is that every change in the system
>> creates a new record and causes a prior record to be invalidated at a
>> point-in-time.  The combination of these two things increases concurrency
>> since you can create new records while people are still using the old
>> ones.
>> One consequence, though, is that it is necessary for the user to decide
>> at
>> what point in the timeline they want to view the database.
>>
>> Does this sound right?
>
> I still do not see how this fits appropriately in the introduction.

The concept or the actual wording?

The intended question was whether my understanding (and simplification) of
the concept is correct.

My specific wording is incoherent mostly because it really belongs to a
larger corpus that currently exists only in my head.

David J.




--
View this message in context: http://postgresql.1045698.n5.nabble.com/MVCC-snapshot-timing-tp5777759p5778033.html
Sent from the PostgreSQL - docs mailing list archive at Nabble.com.


pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: MVCC snapshot timing
Next
From: Bruce Momjian
Date:
Subject: Re: MVCC snapshot timing