Postgres Pro
Downloads
Home   >   mailing lists

Re: Update on true serializable techniques in MVCC - Mailing list pgsql-hackers

From Florian Weimer
Subject Re: Update on true serializable techniques in MVCC
Date
Msg-id 82skb8xp9t.fsf@mid.bfk.de
Whole thread Raw
In response to Re: Update on true serializable techniques in MVCC  (Florian Pflug <fgp.phlo.org@gmail.com>)
Responses Re: Update on true serializable techniques in MVCC  (Nicolas Barbier <nicolas.barbier@gmail.com>)
Re: Update on true serializable techniques in MVCC  (Florian Pflug <fgp.phlo.org@gmail.com>)
Re: Update on true serializable techniques in MVCC  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
Tree view 
* Florian Pflug:

> On 16.12.09 16:40 , Kevin Grittner wrote:
>> Nicolas Barbier<nicolas.barbier@gmail.com>  wrote:
>>
>>> I am not sure whether the serialization failures that it may cause
>>>  are dependent on the plan used.
>>
>> They are.
>
> But so are failures due to deadlocks even today, no?

They are detected.  In this context, "serialization failure" means
that PostgreSQL generates a history which lacks one-copy
serializability, without reporting any errors.  (In the general case,
the unique constraint violation which bugs me personally is a
different beast and does result in an error.)

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Largeobject Access Controls (r2460)
Next
From: Heikki Linnakangas
Date:
Subject: Re: Backup history file should be replicated in Streaming Replication?