Re: logical decoding of two-phase transactions - Mailing list pgsql-hackers

From Andres Freund
Subject Re: logical decoding of two-phase transactions
Date
Msg-id 20170404173133.olo7keeh3dzhriay@alap3.anarazel.de
Whole thread Raw
In response to Re: logical decoding of two-phase transactions  (Stas Kelvich <s.kelvich@postgrespro.ru>)
List pgsql-hackers
On 2017-04-04 13:06:13 +0300, Stas Kelvich wrote:
> That is just argument against Andres concern that prepared transaction
> is able to deadlock with decoding process — at least no such cases in
> regression tests.

There's few longer / adverse xacts, that doesn't say much.


> And that concern is main thing blocking this patch. Except explicit catalog
> locks in prepared tx nobody yet found such cases and it is hard to address
> or argue about.

I doubt that's the case. But even if it were so, it's absolutely not
acceptable that a plain user can cause such deadlocks. So I don't think
this argument buys you anything.

- Andres



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: identity columns
Next
From: Pavan Deolasee
Date:
Subject: Re: Patch: Write Amplification Reduction Method (WARM)