Re: Overhead cost of Serializable Snapshot Isolation

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Overhead cost of Serializable Snapshot Isolation
Дата
Msg-id 20111011202748.GP3007@tinybird.home
обсуждение исходный текст
Ответ на Re: Overhead cost of Serializable Snapshot Isolation  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Overhead cost of Serializable Snapshot Isolation
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Kääriäinen Anssi
Дата:
Сообщение: Re: Index only scan paving the way for "auto" clustered tables?
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: COUNT(*) and index-only scans