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

From: Gurjeet Singh <gurjeet(at)singh(dot)im>
To: Gregory Smith <gregsmithpgsql(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Major pgbench synthetic SELECT workload regression, Ubuntu 23.04+PG15
Date: 2023-06-09 08:05:43
Message-ID: CABwTF4WdsSDTMQW9EephHdjCfjVUT7_P51htzRVdO313bJdF+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jun 9, 2023 at 12:28 AM Gregory Smith <gregsmithpgsql(at)gmail(dot)com> wrote:
>
> Let me start with the happy ending to this thread:

Phew! I'm sure everyone would be relieved to know this was a false alarm.

> On Thu, Jun 8, 2023 at 9:21 PM Andres Freund <andres(at)anarazel(dot)de> wrote:
>>
>> You might need to add --no-children to the perf report invocation, otherwise
>> it'll show you the call graph inverted.
>
>
> My problem was not writing kernel symbols out, I was only getting addresses for some reason. This worked:
>
> sudo perf record -g --call-graph dwarf -d --phys-data -a sleep 1
> perf report --stdio

There is no mention of perf or similar utilities in pgbench-tools
docs. I'm guessing Linux is the primary platform pgbench-tools gets
used on most. If so, I think it'd be useful to mention these tools and
snippets in there to make others lives easier, when they find
themselves scratching heads.

Best regards,
Gurjeet
http://Gurje.et

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Steele 2023-06-09 08:28:48 Views no longer in rangeTabls?
Previous Message Michael Kefeder 2023-06-09 07:58:04 Re: GTIN14 support for contrib/isn