Re: Read only transactions - Commit or Rollback

From: Nicolas Barbier <nicolas(dot)barbier(at)gmail(dot)com>
To: Nörder-Tuitje, Marcus <noerder-tuitje(at)technology(dot)de>
Cc: PostgreSQL Performance List <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Read only transactions - Commit or Rollback
Date: 2005-12-20 13:06:15
Message-ID: b0f3f5a10512200506gf952166w7250483e778d4fdc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 12/20/05, Nörder-Tuitje, Marcus <noerder-tuitje(at)technology(dot)de> wrote:

> MVCC blocks reading processes when data is modified.

That is incorrect. The main difference between 2PL and MVCC is that
readers are never blocked under MVCC.

greetings,
Nicolas

--
Nicolas Barbier
http://www.gnu.org/philosophy/no-word-attachments.html

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Roussel 2005-12-20 13:26:00 Re: filesystem performance with lots of files
Previous Message Markus Schaber 2005-12-20 12:31:53 Re: Read only transactions - Commit or Rollback