From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: MVCC snapshot timing |
Date: | 2013-11-13 01:35:23 |
Message-ID: | 1384306523691-5778033.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-hackers |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2013-11-13 01:39:35 | Re: MVCC snapshot timing |
Previous Message | Bruce Momjian | 2013-11-13 01:29:49 | Re: MVCC snapshot timing |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2013-11-13 01:36:35 | Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ] |
Previous Message | Bruce Momjian | 2013-11-13 01:29:49 | Re: MVCC snapshot timing |