Re: Reliable and fast money transaction design

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Reliable and fast money transaction design
Дата
Msg-id 20070830175408.GG7661@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: Reliable and fast money transaction design  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: Reliable and fast money transaction design
Список pgsql-general
On Wed, Aug 29, 2007 at 10:22:32PM +0100, Gregory Stark wrote:
> mode. In fact I believe SERIALIZABLE mode is actually measurably faster in
> benchmarks but haven't run one in READ COMMITTED mode recently (for that
> reason).

I think there's a reason why SERIALIZABLE could be slower, and that
is that it's waiting on possibly-conflicting (but not actually
conflicting) commits to happen in READ COMMITTED mode.  No?  Won't it
have to check those things when it COMMITs?

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.
        --George Orwell

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

Предыдущее
От: SCassidy@overlandstorage.com
Дата:
Сообщение: Re: accessing PG using Perl:DBI
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Out of Memory - 8.2.4