MIME-Version: 1.0
References: <CAHLJuCUFGcDb1OkBcLtuWoXv5aPbWMj9uSm3q-AR3CA9CcYp_Q@mail.gmail.com>
 <20230608221807.p77h43zotlfvkg65@awork3.anarazel.de> <CAHLJuCVK9Rmxwh-0rmsrbO5-gaiOYsNCN=YE3uQ1ckQaq_YV_A@mail.gmail.com>
 <20230609012147.5j3gw2dikjf76fti@awork3.anarazel.de> <CAHLJuCX0NC7HOZPD-AOXjfQGE8j++sxXkLCcDkWecM_wMJoxzg@mail.gmail.com>
In-Reply-To: <CAHLJuCX0NC7HOZPD-AOXjfQGE8j++sxXkLCcDkWecM_wMJoxzg@mail.gmail.com>
From: Gurjeet Singh <gurjeet@singh.im>
Date: Fri, 9 Jun 2023 01:05:43 -0700
Message-ID: <CABwTF4WdsSDTMQW9EephHdjCfjVUT7_P51htzRVdO313bJdF+w@mail.gmail.com>
Subject: Re: Major pgbench synthetic SELECT workload regression, Ubuntu 23.04+PG15
To: Gregory Smith <gregsmithpgsql@gmail.com>
Cc: Andres Freund <andres@anarazel.de>, 
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CABwTF4WdsSDTMQW9EephHdjCfjVUT7_P51htzRVdO313bJdF%2Bw%40mail.gmail.com>
Precedence: bulk

On Fri, Jun 9, 2023 at 12:28=E2=80=AFAM Gregory Smith <gregsmithpgsql@gmail=
.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=E2=80=AFPM Andres Freund <andres@anarazel.de>=
 wrote:
>>
>> You might need to add --no-children to the perf report invocation, other=
wise
>> it'll show you the call graph inverted.
>
>
> My problem was not writing kernel symbols out, I was only getting address=
es 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