Distributed transactions and asynchronous commit

Поиск
Список
Период
Сортировка
От Xenofon Papadopoulos
Тема Distributed transactions and asynchronous commit
Дата
Msg-id CANL7jAQcVDPC7O8mSEicaJFCjRHdVUtEy=U2WHrKa=HVr0wjGA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Distributed transactions and asynchronous commit  (Vasilis Ventirozos <v.ventirozos@gmail.com>)
Re: Distributed transactions and asynchronous commit  (Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>)
Список pgsql-performance
Дерево обсуждения
In the asynchronous commit documentation, it says:

The commands supporting two-phase commit, such as PREPARE TRANSACTION, are also always synchronous

Does this mean that all queries that are part of a distributed transaction are synchronous?

In our databases we have extremely high disk I/O, I'm wondering if distributed transactions may be the reason behind it.

Thanks

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: General key issues when comparing performance between PostgreSQL and oracle
Следующее
От: Vitalii Tymchyshyn
Дата:
Сообщение: Re: Trying to eliminate union and sort