Re: Reliable and fast money transaction design

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reliable and fast money transaction design
Дата
Msg-id 6851.1188409422@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reliable and fast money transaction design  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Reliable and fast money transaction design
Список pgsql-general
"Joshua D. Drake" <jd@commandprompt.com> writes:
> Tom Lane wrote:
>> "Joshua D. Drake" <jd@commandprompt.com> writes:
>>> SERIALIZABLE is really slow :).
>>
>> Say what?  If anything it's probably faster than READ COMMITTED, because
>> it doesn't take as many snapshots.  But the difference is likely down in
>> the noise anyway.

> Not in production it isn't.

Well, I can believe that specific applications might be slower overall
due to having to retry transactions that get serialization failures,
or perhaps because they take more locks to prevent such failures.
But it's not slower as far as the database engine is concerned.
If you think otherwise I'd like to see a test case.

            regards, tom lane

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

Предыдущее
От: Jeff Amiel
Дата:
Сообщение: SSL and crash woes.
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Reliable and fast money transaction design