Postgres Pro
Downloads
Home   >   mailing lists

Re: Read only transactions - Commit or Rollback - Mailing list pgsql-performance

From Nicolas Barbier
Subject Re: Read only transactions - Commit or Rollback
Date
Msg-id b0f3f5a10512200506gf952166w7250483e778d4fdc@mail.gmail.com
Whole thread Raw
In response to Re: Read only transactions - Commit or Rollback  (Nörder-Tuitje, Marcus <noerder-tuitje@technology.de>)
List pgsql-performance
Tree view 
On 12/20/05, Nörder-Tuitje, Marcus <noerder-tuitje@technology.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

pgsql-performance by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Read only transactions - Commit or Rollback
Next
From: David Roussel
Date:
Subject: Re: filesystem performance with lots of files