Horton

Re: scalability bottlenecks with (many) partitions (and more)

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: Tomas Vondra <tomas@vondra.me>, Andrew Dunstan <andrew@dunslane.net>, Jakub Wartak <jakub.wartak@enterprisedb.com>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-03-04T22:01:18Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Make FP_LOCK_SLOTS_PER_BACKEND look like a function

  2. Fix asserts in fast-path locking code

  3. Increase the number of fast-path lock slots

Andres Freund <andres@anarazel.de> writes:
> On 2025-03-04 16:30:34 -0500, Tom Lane wrote:
>> Yeah, I've been poking at that.  It's not at all clear why the
>> animal is trying to run src/test/modules/ldap_password_func
>> now when it didn't before.

> It did do so before as well, afaict:
> https://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=sifaka&dt=2025-03-04%2015%3A01%3A42&stg=module-ldap_password_func-check

> It seems to me that the difference is that now checkprep is run, whereas
> previously it wasn't.

Maybe, but still I don't see any changes in the BF client that'd
explain it.  The animal's configuration hasn't changed either;
the only non-comment diff in its buildfarm.conf is

@@ -374,7 +376,7 @@
 
        base_port => 5678,
 
-       modules => [qw(TestUpgrade TestDecoding)],
+       modules => [qw(TestUpgrade)],
 
        # settings used by run_branches.pl
        global => {

which I changed to follow the lead of build-farm.conf.sample.
But surely that wouldn't affect this!?

			regards, tom lane