| From: | Nicola Contu <nicola(dot)contu(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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 16:01:09 |
| Message-ID: | CAMTZZh39S_miLXFXRTOGEa51e5ZJ6=r7U8DT5Cb_Ed3yUxQuxA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Attached a part of the strace running the pgbench command for pg11
Also attached strace_10 for pg10.6.
Thanks
Il giorno lun 4 mar 2019 alle ore 15:22 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> ha
scritto:
> 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
>
| Attachment | Content-Type | Size |
|---|---|---|
| strace.txt | text/plain | 64.4 KB |
| strace_10.txt | text/plain | 63.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eugen Stan | 2019-03-04 16:42:40 | Re: support for JSON Web Token |
| Previous Message | Arthur Zakirov | 2019-03-04 15:53:31 | Re: query logging of prepared statements |