Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VgPHG-0004bO-Q9 for pgsql-docs@arkaria.postgresql.org; Wed, 13 Nov 2013 01:29:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VgPHG-0001zG-9h for pgsql-docs@arkaria.postgresql.org; Wed, 13 Nov 2013 01:29:54 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VgPHF-0001zA-JS for pgsql-docs@postgresql.org; Wed, 13 Nov 2013 01:29:53 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VgPHC-0001PE-TY for pgsql-docs@postgresql.org; Wed, 13 Nov 2013 01:29:52 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1VgPHB-0002SF-La; Tue, 12 Nov 2013 20:29:49 -0500 Date: Tue, 12 Nov 2013 20:29:49 -0500 From: Bruce Momjian To: David Johnston Cc: pgsql-docs@postgresql.org Subject: Re: MVCC snapshot timing Message-ID: <20131113012949.GA24549@momjian.us> References: <20131111175737.GA15562@momjian.us> <13024.1384202385@sss.pgh.pa.us> <20131111205833.GC15562@momjian.us> <20331.1384221575@sss.pgh.pa.us> <20131112021954.GD15562@momjian.us> <21328.1384223235@sss.pgh.pa.us> <20131112024609.GG15562@momjian.us> <1384226759124-5777852.post@n5.nabble.com> <20131112151427.GH15562@momjian.us> <1384299361317-5778016.post@n5.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1384299361317-5778016.post@n5.nabble.com> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -0.5 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org 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 http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs