Josh Berkus <j...@agliodbs.com> wrote: > So, at least theoretically, anyone who had a traffic mix similar to > TPCE would benefit. Particularly, some long-running serializable > transactions thrown into a mix of Read Committed and Repeatable > Read transactions, for a stored procedure driven application. A belated thought. The proposed technique does yield different behavior from traditional techniques for Read Committed and Repeatable Read transactions which are run concurrently with Serializable transactions. In traditional blocking techniques, even a Read Committed transaction only sees the database in a state consistent with some serial execution of the serializable transactions. As far as I can see, this is not required by the SQL standard, but it might possibly be an implementation artifact upon which some software might rely. Any idea whether this is the case with the TPC-E benchmark? -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers