Re: MVCC snapshot timing

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.

In response to

Responses

Browse pgsql-docs by date

  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

Browse pgsql-hackers by date

  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