Re: Overhead cost of Serializable Snapshot Isolation
Greg Sabino Mullane <greg@endpoint.com>
From: Greg Sabino Mullane <greg@endpoint.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2011-10-11T20:27:48Z
Lists: pgsql-hackers
> If the normal default_transaction_isolation = read committed and all > transactions that require serializable are explicitly marked in the > application then there is no way to turn off SSI without altering the > application. That is not acceptable, since it causes changes in > application behaviour and possibly also performance issues. Performance, perhaps. What application behavior changes? Less serialization conflicts? > We should provide a mechanism to allow people to upgrade to 9.1+ > without needing to change the meaning and/or performance of their > apps. That ship has sailed. -- Greg Sabino Mullane greg@endpoint.com End Point Corporation PGP Key: 0x14964AC8