Re: Prepared Transactions

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: Prepared Transactions
Дата
Msg-id 96631512980099@web21g.yandex.ru
обсуждение исходный текст
Ответ на Prepared Transactions  (Riaan Stander <rstander@exa.co.za>)
Ответы Re: Prepared Transactions  (jwhiting@redhat.com)
Список pgsql-performance
Hello!

You need prepared transactions only if you need two-phase commit to provide distributed atomic transaction on multiple
differentdatabases.
 
If you not need distributed transactions - you not needed prepared transactions at all.
But if you need distributed transactions - here is no more choice regardless performance questions.

As say in documentation https://www.postgresql.org/docs/current/static/sql-prepare-transaction.html
> Unless you're writing a transaction manager, you probably shouldn't be using PREPARE TRANSACTION.

Regards, Sergei


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

Предыдущее
От: Riaan Stander
Дата:
Сообщение: Prepared Transactions
Следующее
От: jwhiting@redhat.com
Дата:
Сообщение: Re: Prepared Transactions