Re: Major pgbench synthetic SELECT workload regression, Ubuntu 23.04+PG15

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Major pgbench synthetic SELECT workload regression, Ubuntu 23.04+PG15
Дата
Msg-id 20230609012147.5j3gw2dikjf76fti@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: Major pgbench synthetic SELECT workload regression, Ubuntu 23.04+PG15  (Gregory Smith <gregsmithpgsql@gmail.com>)
Ответы Re: Major pgbench synthetic SELECT workload regression, Ubuntu 23.04+PG15  (Gregory Smith <gregsmithpgsql@gmail.com>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: index prefetching
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: running logical replication as the subscription owner