This is instead the strace of another server running the same version compiled but that is even slower.
Il giorno mer 6 mar 2019 alle ore 11:14 Nicola Contu <nicola.contu@gmail.com> ha scritto:
Here is the strace as requested for pg11
Thanks
Il giorno mar 5 mar 2019 alle ore 17:47 Thomas Munro <thomas.munro@gmail.com> ha scritto:
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:
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.