Content-Type: multipart/alternative;
 boundary="------------j5kdn3hkdI7vcHHnshdd6InI"
Message-ID: <b6c413ee-19a4-f3a8-9772-210049c22369@gmail.com>
Date: Fri, 4 Mar 2022 21:33:01 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.5.0
To: Pgsql Performance <pgsql-performance@lists.postgresql.org>
Content-Language: en-US
From: Mladen Gogala <gogala.mladen@gmail.com>
Subject: XA transactions much slower on 14.2 than on 13.5
Archived-At: 
 <https://www.postgresql.org/message-id/b6c413ee-19a4-f3a8-9772-210049c22369%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------j5kdn3hkdI7vcHHnshdd6InI
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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

--------------j5kdn3hkdI7vcHHnshdd6InI
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>My boss asked me to upgrade one of the development  databases
      from 13.5 --&gt; 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?</p>
    <p>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.<br>
    </p>
    Regards
    <pre class="moz-signature" cols="72">-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
<a class="moz-txt-link-freetext" href="https://dbwhisperer.wordpress.com">https://dbwhisperer.wordpress.com</a>
</pre>
  </body>
</html>

--------------j5kdn3hkdI7vcHHnshdd6InI--