pgsql: Increase timeout in multixid_conversion upgrade test

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Increase timeout in multixid_conversion upgrade test
Date: 2025-12-15 16:11:01
Message-ID: E1vVBA4-000vfZ-0w@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Increase timeout in multixid_conversion upgrade test

The workload to generate multixids before upgrade is very slow on
buildfarm members running with JIT enabled. The workload runs a lot of
small queries, so it's unsurprising that JIT makes it slower. On my
laptop it nevertheless runs in under 10 s even with JIT enabled, while
some buildfarm members have been hitting the 180 s timeout. That seems
extreme, but I suppose it's still expected on very slow and busy
buildfarm animals. The timeout applies to the BackgroundPsql sessions
as whole rather than the individual queries.

Bump up the timeout to avoid the test failures. Add periodic progress
reports to the test output so that we get a better picture of just how
slow the test is.

In the passing, also fix comments about how many multixids and members
the workload generates. The comments were written based on 10 parallel
connections, but it actually uses 20.

Discussion: https://www.postgresql.org/message-id/b7faf07c-7d2c-4f35-8c43-392e057153ef@gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/bd43940b02b292c836e912a8f9423f771ec15fab

Modified Files
--------------
src/bin/pg_upgrade/t/007_multixact_conversion.pl | 25 +++++++++++++++++-------
1 file changed, 18 insertions(+), 7 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2025-12-15 17:40:42 pgsql: Add offnum range checks to suppress compile warnings with UBSAN.
Previous Message Robert Haas 2025-12-15 15:07:21 Re: pgsql: Add function to log the memory contexts of specified backend pro