Re: Distributed transactions and asynchronous commit - Mailing list pgsql-performance

From Vasilis Ventirozos
Subject Re: Distributed transactions and asynchronous commit
Date
Msg-id CAF8jcqorADWnQj7SNoO=yBA-s1HUo=0XpeBtrEcMjB6e0vjK5g@mail.gmail.com
Whole thread Raw
In response to Distributed transactions and asynchronous commit  (Xenofon Papadopoulos <xpapad@gmail.com>)
List 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 by date:

Previous
From: Vitalii Tymchyshyn
Date:
Subject: Re: Trying to eliminate union and sort
Next
From: Giuseppe Broccolo
Date:
Subject: Re: Distributed transactions and asynchronous commit