Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 - Mailing list pgsql-general

From Thomas Munro
Subject Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2
Date
Msg-id CA+hUKGJXQ8Zg3Vy66-U7iCDjRqjkcH11+yCXxa=MEwLq+HZoAg@mail.gmail.com
Whole thread Raw
In response to Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2  (Nicola Contu <nicola.contu@gmail.com>)
Responses Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2  (Nicola Contu <nicola.contu@gmail.com>)
List pgsql-general
On Tue, Mar 5, 2019 at 5:01 AM Nicola Contu <nicola.contu@gmail.com> wrote:
> Attached a part of the strace running the pgbench command for pg11
> Also attached strace_10 for pg10.6.

That looks like strace output from pgbench, and I don't see any
interesting differences between v10 and v11 (though I'm surprised to
see it using poll() instead of ppoll(), and opening a new connection
for every transaction).

How about syscalls on the server side?  You could start it with
something like "strace -f path/to/postgres -D path/to/pgdata" (-f for
follow children), and perhaps also use -c so that it shows aggregated
data (up until you ^C it) instead of every syscall?

-- 
Thomas Munro
https://enterprisedb.com


pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Optimizing Database High CPU
Next
From: Perumal Raj
Date:
Subject: Re: Question about pg_upgrade from 9.2 to X.X