Re: MVCC snapshot timing

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: David Johnston <polobo(at)yahoo(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: MVCC snapshot timing
Date: 2013-11-13 01:29:49
Message-ID: 20131113012949.GA24549@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

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.

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

+ Everyone has their own god. +

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David Johnston 2013-11-13 01:35:23 Re: MVCC snapshot timing
Previous Message David Johnston 2013-11-12 23:36:01 Re: MVCC snapshot timing

Browse pgsql-hackers by date

  From Date Subject
Next Message David Johnston 2013-11-13 01:35:23 Re: MVCC snapshot timing
Previous Message Tom Lane 2013-11-13 00:59:51 Re: Clang 3.3 Analyzer Results