Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nicola Contu <nicola(dot)contu(at)gmail(dot)com>
Cc: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, "Ray O'Donnell" <ray(at)rodonnell(dot)ie>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, Alessandro Aste <Alessandro(dot)aste(at)gtt(dot)net>
Subject: Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2
Date: 2019-03-04 14:22:28
Message-ID: 32290.1551709348@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nicola Contu <nicola(dot)contu(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arthur Zakirov 2019-03-04 15:53:31 Re: query logging of prepared statements
Previous Message Derek Hans 2019-03-04 14:00:50 Re: Update does not move row across foreign partitions in v11