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

Hi,

On 2025-03-04 19:58:38 +0100, Tomas Vondra wrote:
> Pushed, with the tweaks to use FastPathLockSlotsPerBackend() in a couple
> more places.

Thanks!


> I noticed sifaka started failing right after I pushed this:
> 
> https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=sifaka&br=master
> 
> But I have no idea why would this cosmetic change cause issues with LDAP
> tests, so I'm assuming the failure is unrelated, and the timing is
> accidental and not caused by the patch.

The buildfarm was updated between those two runs.

https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=sifaka&dt=2025-03-04%2015%3A01%3A42
has
                                          'PGBuild::Log' => 'REL_18',
whereas the failing run
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=sifaka&dt=2025-03-04%2017%3A35%3A40
has
                                          'PGBuild::Log' => 'REL_19',

It's worth noting that
a) sifaka doesn't build with ldap support
b) the failure is in checkprep, not when running the tests
c) the buildfarm unfortunately doesn't archive install.log, so it's hard to
   know what actually went wrong

Greetings,

Andres Freund