From: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Serializable implementation |
Date: | 2009-12-28 23:20:33 |
Message-ID: | 4B393D41.7060400@phlo.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 28.12.09 18:54 , Kevin Grittner wrote:
> To give some idea of the scope of development, Michael Cahill added
> SSI to InnoDB by modifying 250 lines of code and adding 450 lines of
> code; however, InnoDB already had the S2PL option and the prototype
> implementation isn't as sophisticated as I feel is necessary for
> real production use (particularly regarding the granularity of SIREAD
> locks). I'm assuming it would take more to reach real production
> quality in PostgreSQL. My SWAG would be to multiply by two or
> three.
I believe the hard part of implementing true serializability is not the
actual SSI or S2PL algorithm, but rather the necessary predicate locking
strategy.
So I think checking how InnoDB tackles that and how much of it's code is
invovled might give a more realistic estimate of the effort required.
best regards,
Florian Plug
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2009-12-28 23:20:35 | Re: [HACKERS] Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) |
Previous Message | Jeff Davis | 2009-12-28 23:15:38 | Re: Serializable implementation |