Re: Overhead cost of Serializable Snapshot Isolation

Kevin Grittner <kevin.grittner@wicourts.gov>

From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>

To: "Simon Riggs" <simon@2ndQuadrant.com>, "Heikki Linnakangas" <heikki.linnakangas@enterprisedb.com>

Cc: "Greg Sabino Mullane" <greg@endpoint.com>, "pgsql-hackers" <pgsql-hackers@postgresql.org>

Date: 2011-10-10T22:31:34Z

Lists: pgsql-hackers

Simon Riggs <simon@2ndQuadrant.com> wrote:
 
> How do we turn it on/off to allow the overhead to be measured?
 
User REPEATABLE READ transactions or SERIALIZABLE transactions.  The
easiest way, if you're doing it for all transactions (which I
recommend) is to set default_transaction_isolation.
 
-Kevin