Postgres Pro
Downloads
Home   >   mailing lists

Re: Major pgbench synthetic SELECT workload regression, Ubuntu 23.04+PG15 - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Major pgbench synthetic SELECT workload regression, Ubuntu 23.04+PG15
Date
Msg-id 20230609012147.5j3gw2dikjf76fti@awork3.anarazel.de
Whole thread Raw
In response to Re: Major pgbench synthetic SELECT workload regression, Ubuntu 23.04+PG15  (Gregory Smith <gregsmithpgsql@gmail.com>)
Responses Re: Major pgbench synthetic SELECT workload regression, Ubuntu 23.04+PG15
List pgsql-hackers
Tree view 
Hi,

On 2023-06-08 20:20:18 -0400, Gregory Smith wrote:
> On Thu, Jun 8, 2023 at 6:18 PM Andres Freund <andres@anarazel.de> wrote:
> 
> > Could you get a profile with call graphs? We need to know what leads to all
> > those osq_lock calls.
> > perf record --call-graph dwarf -a sleep 1
> > or such should do the trick, if run while the workload is running.
> >
> 
> I'm doing something wrong because I can't find the slow part in the perf
> data; I'll get back to you on this one.

You might need to add --no-children to the perf report invocation, otherwise
it'll show you the call graph inverted.

- Andres

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: index prefetching
Next
From: Masahiko Sawada
Date:
Subject: Re: running logical replication as the subscription owner