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

From Tom Lane
Subject Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2
Date
Msg-id 32290.1551709348@sss.pgh.pa.us
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
Nicola Contu <nicola.contu@gmail.com> writes:
> See attached perf report. The difference seems to be all in this line, but
> not sure :
> +   26.80%     0.00%           222  postmaster       [kernel.kallsyms]
>               [k] system_call_fastpath

That would suggest that many more kernel calls are happening, which is
something you could usefully investigate with strace, perhaps.

            regards, tom lane


pgsql-general by date:

Previous
From: Derek Hans
Date:
Subject: Re: Update does not move row across foreign partitions in v11
Next
From: Nicola Contu
Date:
Subject: Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2