Re: Distributed transactions and asynchronous commit

From: Vasilis Ventirozos <v(dot)ventirozos(at)gmail(dot)com>
To: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Distributed transactions and asynchronous commit
Date: 2013-07-17 09:28:50
Message-ID: CAF8jcqorADWnQj7SNoO=yBA-s1HUo=0XpeBtrEcMjB6e0vjK5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Giuseppe Broccolo 2013-07-17 10:09:17 Re: Distributed transactions and asynchronous commit
Previous Message Vitalii Tymchyshyn 2013-07-17 08:24:40 Re: Trying to eliminate union and sort