Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2

On Wed, Mar 6, 2019 at 4:22 AM Nicola Contu <nicola.contu@gmail.com> wrote:
>
> Not sure what you are requesting exactly but here is the strace for the start of the pg_ctl

I meant that you could run the server itself in the foreground under
strace, like so:

$ strace -f -c /usr/local/pgsql11.2/bin/postgres -D /db/pgsql11/data/

Then perform your testing, and finally stop it with pg_ctl from
another window (or hit ^C in this window) and strace should spit out a
table of system calls with some counters.  We might be able to see why
v11 is spending so much more time executing system calls than v10 for
your workload, or at least which systems calls they are, assuming you
run the same transactions against both versions.

--
Thomas Munro
https://enterprisedb.com