Re: Distributed transactions and asynchronous commit

Поиск
Список
Период
Сортировка
От Vasilis Ventirozos
Тема Re: Distributed transactions and asynchronous commit
Дата
Msg-id CAF8jcqorADWnQj7SNoO=yBA-s1HUo=0XpeBtrEcMjB6e0vjK5g@mail.gmail.com
обсуждение исходный текст
Ответ на Distributed transactions and asynchronous commit  (Xenofon Papadopoulos <xpapad@gmail.com>)
Список 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?

Yep
 
In our databases we have extremely high disk I/O, I'm wondering if distributed transactions may be the reason behind it.
 
could be, but you have to send us more info about your setup, your configuration , especially your io settings, output of vmstats would also be helpful
 
Thanks


Vasilis Ventirozos

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

Предыдущее
От: Vitalii Tymchyshyn
Дата:
Сообщение: Re: Trying to eliminate union and sort
Следующее
От: Giuseppe Broccolo
Дата:
Сообщение: Re: Distributed transactions and asynchronous commit