Anthony Berglas wrote:
> Thanks for doing the test in Oracle. What I did not see is you setting the
> Isolation Level. Or maybe that is what I forgot to do when I did similar
> tests some time ago! (I don't have Oracle handy or I'd try again.)
>
> However, the point remains, that there is no reason why PostgreSQL could not
> provide more serialized transactions in Read Committed mode without taking
> the hits with rollback that Serializable mode gives.
Yes, we could probably do it, but it doesn't make sense for SELECT to
use SERIALIZABLE while in the same transaction UPDATE/DELETE is using
READ COMMITTED. Seems that would cause all sorts of confusion.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026