Re: Potential "AIO / io workers" inter-worker locking issue in PG18?

Hi Andres,

Thanks for the suggestion, this seems a useful option.

However, when I attempt to run "perf top" in a Terminal window, I get
the following warning:

WARNING: perf not found for kernel 6.14.0-1012

I also see a suggestion to install the Azure linux-tools. However, if I
type 'linux-tools' as search keyword in Synaptic Package Manager, I see
a whole bunch of 'linux-tools', e.g. azure/aws/gcp/gke, which also
include kernel version build numbers (at least that is what I assume
they are).

What version do you suggest I install for an ordinary locally running
Ubuntu 24.04 VM?

And do these packages indeed add the perf command?

Marco

Op 6-10-2025 om 18:21 schreef Andres Freund:
> Hi,
>
> On 2025-10-06 18:17:11 +0200, Marco Boeringa wrote:
>> Hi Andras,
>>
>> I am not really a Linux / Ubuntu expert. Can you give me a suggestion for
>> how to create such a CPU profile for the specific PostgreSQL processes
>> getting stuck?
> https://wiki.postgresql.org/wiki/Profiling_with_perf is a good starting point.
>
> Greetings,
>
> Andres