Horton

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

Andrew Dunstan <andrew@dunslane.net>

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

On 2025-03-04 Tu 5:01 PM, Tom Lane wrote:
> 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!?
>
> 			



I think I found a logic bug. Testing.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com