public inbox for [email protected]  

help / color / mirror / Atom feed

From: Bruce Momjian <[email protected]>
To: David Johnston <[email protected]>
Cc: [email protected]
Subject: Re: MVCC snapshot timing
Date: Tue, 12 Nov 2013 20:39:35 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

On Tue, Nov 12, 2013 at 05:35:23PM -0800, David Johnston wrote:
> 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.

Oh, OK, it sounds fine.  The user really doesn't choose what timeline to
see --- rather, it is the current xid at the time they take their
snapshot and other running xids that controls that.  You can control
your transaction isolation level, but that only controls how often you
take snapshots.

-- 
  Bruce Momjian  <[email protected]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

view thread (17+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: MVCC snapshot timing
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox