Re: Prepared Transactions - Mailing list pgsql-performance

From Sergei Kornilov
Subject Re: Prepared Transactions
Date
Msg-id 96631512980099@web21g.yandex.ru
Whole thread Raw
In response to Prepared Transactions  (Riaan Stander <rstander@exa.co.za>)
Responses Re: Prepared Transactions  (jwhiting@redhat.com)
List pgsql-performance
Hello!

You need prepared transactions only if you need two-phase commit to provide distributed atomic transaction on multiple
differentdatabases.
 
If you not need distributed transactions - you not needed prepared transactions at all.
But if you need distributed transactions - here is no more choice regardless performance questions.

As say in documentation https://www.postgresql.org/docs/current/static/sql-prepare-transaction.html
> Unless you're writing a transaction manager, you probably shouldn't be using PREPARE TRANSACTION.

Regards, Sergei


pgsql-performance by date:

Previous
From: Riaan Stander
Date:
Subject: Prepared Transactions
Next
From: jwhiting@redhat.com
Date:
Subject: Re: Prepared Transactions