Postgres Pro
Downloads
Home   >   mailing lists

Distributed transactions and asynchronous commit - Mailing list pgsql-performance

From Xenofon Papadopoulos
Subject Distributed transactions and asynchronous commit
Date
Msg-id CANL7jAQcVDPC7O8mSEicaJFCjRHdVUtEy=U2WHrKa=HVr0wjGA@mail.gmail.com
Whole thread Raw
Responses Re: Distributed transactions and asynchronous commit  (Vasilis Ventirozos <v.ventirozos@gmail.com>)
Re: Distributed transactions and asynchronous commit  (Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>)
List pgsql-performance
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: General key issues when comparing performance between PostgreSQL and oracle
Next
From: Vitalii Tymchyshyn
Date:
Subject: Re: Trying to eliminate union and sort