Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2

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(dot)contu(at)gmail(dot)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(dot)munro(at)gmail(dot)com> ha scritto:
>
>> On Wed, Mar 6, 2019 at 4:22 AM Nicola Contu <nicola(dot)contu(at)gmail(dot)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
>>
>