public inbox for [email protected]
help / color / mirror / Atom feedFrom: Gregory Smith <[email protected]>
To: Gurjeet Singh <[email protected]>
Cc: Andres Freund <[email protected]>
Cc: PostgreSQL-development <[email protected]>
Subject: Re: Major pgbench synthetic SELECT workload regression, Ubuntu 23.04+PG15
Date: Fri, 9 Jun 2023 08:52:33 -0400
Message-ID: <CAHLJuCX9nf_T6DhJV_ohAuCUOS0RGR7YpWBEZNF7a5oVyNnuow@mail.gmail.com> (raw)
In-Reply-To: <CABwTF4WdsSDTMQW9EephHdjCfjVUT7_P51htzRVdO313bJdF+w@mail.gmail.com>
References: <CAHLJuCUFGcDb1OkBcLtuWoXv5aPbWMj9uSm3q-AR3CA9CcYp_Q@mail.gmail.com>
<[email protected]>
<CAHLJuCVK9Rmxwh-0rmsrbO5-gaiOYsNCN=YE3uQ1ckQaq_YV_A@mail.gmail.com>
<[email protected]>
<CAHLJuCX0NC7HOZPD-AOXjfQGE8j++sxXkLCcDkWecM_wMJoxzg@mail.gmail.com>
<CABwTF4WdsSDTMQW9EephHdjCfjVUT7_P51htzRVdO313bJdF+w@mail.gmail.com>
On Fri, Jun 9, 2023 at 4:06 AM Gurjeet Singh <[email protected]> wrote:
> 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.
That's a good idea. I've written out guides multiple times for customers
who are crashing and need to learn about stack traces, to help them becomes
self-sufficient with the troubleshooting parts it's impractical for me to
do for them. If I can talk people through gdb, I can teach them perf. I
have a lot of time to work on pgbench-tools set aside this summer, gonna
finally deprecate the gnuplot backend and make every graph as nice as the
ones I shared here.
I haven't been aggressive about pushing perf because a lot of customers at
Crunchy--a disproportionately larger number than typical I suspect--have
operations restrictions that just don't allow DBAs direct access to a
server's command line. So perf commands are just out of reach before we
even get to the permissions it requires. I may have to do something really
wild to help them, like see if the right permissions setup would allow
PL/python3 or similar to orchestrate a perf session in a SQL function.
view thread (9+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Major pgbench synthetic SELECT workload regression, Ubuntu 23.04+PG15
In-Reply-To: <CAHLJuCX9nf_T6DhJV_ohAuCUOS0RGR7YpWBEZNF7a5oVyNnuow@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox