Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M7823=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1Vg3Gb-0008Gd-Sm
 for pgsql-docs@arkaria.postgresql.org; Tue, 12 Nov 2013 01:59:46 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M7823=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1Vg3Gb-0003Lh-Bt
 for pgsql-docs@arkaria.postgresql.org; Tue, 12 Nov 2013 01:59:45 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <tgl@sss.pgh.pa.us>) id 1Vg3Ga-0003Lb-RZ
 for pgsql-docs@postgresql.org; Tue, 12 Nov 2013 01:59:44 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <tgl@sss.pgh.pa.us>) id 1Vg3GY-0006zR-DT
 for pgsql-docs@postgresql.org; Tue, 12 Nov 2013 01:59:44 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
 by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id rAC1xZ9V020332;
 Mon, 11 Nov 2013 20:59:35 -0500
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
cc: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: Re: MVCC snapshot timing
In-reply-to: <20131111205833.GC15562@momjian.us>
References: <20131111175737.GA15562@momjian.us>
 <13024.1384202385@sss.pgh.pa.us> <20131111205833.GC15562@momjian.us>
Comments: In-reply-to Bruce Momjian <bruce@momjian.us>
 message dated "Mon, 11 Nov 2013 15:58:33 -0500"
Date: Mon, 11 Nov 2013 20:59:35 -0500
Message-ID: <20331.1384221575@sss.pgh.pa.us>
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

Bruce Momjian <bruce@momjian.us> writes:
> On Mon, Nov 11, 2013 at 03:39:45PM -0500, Tom Lane wrote:
>> I'm not really seeing the point of s/transaction/session/ here.

> Well, the problem with the original wording is that we don't take a new
> snapshot for every transaction in the default read-committed mode. 

We take at least one snapshot per transaction, in any mode.  Referring
to sessions makes it even further away from being a useful concept.

> Would you prefer I refer to statements, e.g.:

'Statement' might work.

			regards, tom lane


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