Postgres Pro
Downloads
Home   >   mailing lists

XA transactions much slower on 14.2 than on 13.5 - Mailing list pgsql-performance

From Mladen Gogala
Subject XA transactions much slower on 14.2 than on 13.5
Date
Msg-id b6c413ee-19a4-f3a8-9772-210049c22369@gmail.com
Whole thread Raw
Responses Re: XA transactions much slower on 14.2 than on 13.5  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view

My boss asked me to upgrade one of the development  databases from 13.5 --> 14.2. One thing that we've noticed right away is that XA transactions (2-phase commit) are much slower on 14.2 than on 13.5. Were there any significant changes to the XA protocol in the version 14? Did anybody else encountered this problem?

When I say "XA transactions are much slower", I mean that commit and/or rollback take much longer. The SQL execution takes the same and the plans are identical to the 13.5 version. The application code is the same, using IBM WebSphere 9.0.4.
Regards 

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

pgsql-performance by date:

Previous
From: Imre Samu
Date:
Subject: Re: Any way to speed up INSERT INTO
Next
From: Tom Lane
Date:
Subject: Re: XA transactions much slower on 14.2 than on 13.5