Re: Overhead cost of Serializable Snapshot Isolation

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Greg Sabino Mullane <greg@endpoint.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2011-10-11T20:51:19Z
Lists: pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> There is no off switch and there should be.

As Greg said, that ship has sailed.  I believe that we specifically
discussed the notion of an "off switch" via a GUC or similar during
9.1 development, and rejected it on the grounds that GUCs changing
fundamental transactional behavior are dangerous.  I don't believe that
you've made a case for changing that decision, and even if you had,
it's too late; 9.1 is what it is.  Can we end this subthread please,
and concentrate on something actually useful, like improving SSI's
performance?

			regards, tom lane