Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
Date
Msg-id 20160612215140.znmnl4mpzvgxjmgn@alap3.anarazel.de
Whole thread Raw
Responses Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6  (Vladimir Borodin <root@simply.name>)
List pgsql-hackers
Hi Vladimir,

Thanks for these reports.

On 2016-06-13 00:42:19 +0300, Vladimir Borodin wrote:
> perf report -g -i pg9?_all.data >/tmp/pg9?_perf_report.txt

Any chance you could redo the reports with --no-children --call-graph=fractal
added? The mode that includes child overheads unfortunately makes the
output hard to interpet/compare.

> The results from pg9?_perf_report.txt are attached. Note that in all cases some events were lost, i.e.:
>
> root@pgload05g ~ # perf report -g -i pg94_all.data >/tmp/pg94_perf_report.txt
> Failed to open [vsyscall], continuing without symbols
> Warning:
> Processed 537137 events and lost 7846 chunks!

You can reduce the overhead by reducing the sampling frequency, e.g. by
specifying -F 300.

Greetings,

Andres Freund


pgsql-hackers by date:

Previous
From: Ioseph Kim
Date:
Subject: increase message string buffer size of watch command of psql
Next
From: Thom Brown
Date:
Subject: Re: Confusing recovery message when target not hit