Hello Andrew,
On Wed, March 1, 2006 17:31, Andrew Piskorski wrote:
> Is that in fact true? I am not familiar with how PostgreSQL
> implements the SERIALIZABLE isolation level, but I assume that
> PostgreSQL's MVCC would still give some advantage even under
> SERIALIZABLE: It should allow the readers and (at least one of) the
> writers to run concurrently. Am I mistaken?
PostgreSQL always played the "readers are never blocked" mantra. Nevertheless
I really wonder how the strict serializable constraints could be satisfied
without blocking the readers while a write is in place.
Bye,
--
Denis Sbragion
InfoTecna
Tel: +39 0362 805396, Fax: +39 0362 805404
URL: http://www.infotecna.it
