Re: Prepared Transactions

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: Riaan Stander <rstander(at)exa(dot)co(dot)za>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Prepared Transactions
Date: 2017-12-11 08:14:59
Message-ID: 96631512980099@web21g.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello!

You need prepared transactions only if you need two-phase commit to provide distributed atomic transaction on multiple different databases.
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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message jwhiting 2017-12-11 12:13:23 Re: Prepared Transactions
Previous Message Riaan Stander 2017-12-11 00:39:40 Prepared Transactions