Re: scalability bottlenecks with (many) partitions (and more) - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: scalability bottlenecks with (many) partitions (and more)
Date
Msg-id d5499660-1541-4749-aff4-6be88be76d99@vondra.me
Whole thread Raw
In response to Re: scalability bottlenecks with (many) partitions (and more)  (Tomas Vondra <tomas@vondra.me>)
Responses Re: scalability bottlenecks with (many) partitions (and more)
List pgsql-hackers
On 3/4/25 15:38, Tomas Vondra wrote:
> 
> ...
>
>>>
>>> Attached is a patch doing this, but considering it has nothing to do
>>> with the shmem sizing, I wonder if it's worth it.
>>
>> Yes.
>>
> 
> OK, barring objections I'll push the v2.
> 

Pushed, with the tweaks to use FastPathLockSlotsPerBackend() in a couple
more places.

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.


regards

-- 
Tomas Vondra




pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: making EXPLAIN extensible
Next
From: Andres Freund
Date:
Subject: AIO v2.5