pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-performance@postgresql.org
To: Steve Wong <powerpchead@yahoo.com>
Subject: Re: MVCC and Implications for (Near) Real-Time Application
Date: Fri, 29 Oct 2010 12:18:20 -0500
Message-ID: <4CCABB8C0200002500036F8D@gw.wicourts.gov> (raw)
In-Reply-To: <203952.56702.qm@web111712.mail.gq1.yahoo.com>
References: <203952.56702.qm@web111712.mail.gq1.yahoo.com>

Steve Wong <powerpchead@yahoo.com> wrote:
 
> (1) Does the MVCC architecture introduce significant delays
> between insert by a thread and visibility by other threads (I am
> unclear about how multiple versions are "collapsed" or reconciled,
> as well as how different query threads are seeing which version)?
 
As soon as the inserting transaction commits the inserted row is
visible to new snapshots.  If you are in an explicit transaction the
commit will have occurred before the return from the COMMIT request;
otherwise it will have completed before the return from the INSERT
request.
 
You will get a new snapshot for every statement in READ COMMITTED
(or lower) transaction isolation.  You will get a new snapshot for
each database transaction in higher isolation levels.
 
-Kevin



view thread (3+ messages)

Message-ID: <4CCABB8C0200002500036F8D@gw.wicourts.gov>
Permalink:  ../4CCABB8C0200002500036F8D@gw.wicourts.gov/
Also on:    postgresql.org/message-id/4CCABB8C0200002500036F8D@gw.wicourts.gov

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: Kevin.Grittner@wicourts.gov, powerpchead@yahoo.com
  Subject: Re: MVCC and Implications for (Near) Real-Time Application
  In-Reply-To: <4CCABB8C0200002500036F8D@gw.wicourts.gov>
  References: <203952.56702.qm@web111712.mail.gq1.yahoo.com> <4CCABB8C0200002500036F8D@gw.wicourts.gov>

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

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