public inbox for [email protected]
help / color / mirror / Atom feedFrom: Vladimir Borodin <[email protected]>
To: Andres Freund <[email protected]>
Cc: [email protected]
Cc: PostgreSQL-development <[email protected]>
Subject: Re: [HACKERS] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
Date: Mon, 4 Jul 2016 16:30:51 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
> 13 июня 2016 г., в 21:58, Vladimir Borodin <[email protected]> написал(а):
>
>>
>> 13 июня 2016 г., в 0:51, Andres Freund <[email protected] <mailto:[email protected]>> написал(а):
>>
>> 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.
>
> Of course. Not sure if that is important but I upgraded perf for that (because --no-children option was introduced in ~3.16), so perf record and perf report were done with different perf versions.
>
> <pg94_perf_report.txt.gz>
> <pg95_perf_report.txt.gz>
> <pg96_perf_report.txt.gz>
>
> Also I’ve done the same test on same host (RHEL 6) but with 4.6 kernel/perf and writing perf data to /dev/shm for not loosing events. Perf report output is also attached but important thing is that the regression is not so significant:
>
> root@pgload05g ~ # uname -r
> 4.6.0-1.el6.elrepo.x86_64
> root@pgload05g ~ # cat /proc/sys/kernel/sched_autogroup_enabled
> 1
> root@pgload05g ~ # /tmp/run.sh
> RHEL 6 9.4 71634 0.893
> RHEL 6 9.5 54005 1.185
> RHEL 6 9.6 65550 0.976
> root@pgload05g ~ # echo 0 >/proc/sys/kernel/sched_autogroup_enabled
> root@pgload05g ~ # /tmp/run.sh
> RHEL 6 9.4 73041 0.876
> RHEL 6 9.5 60105 1.065
> RHEL 6 9.6 67984 0.941
> root@pgload05g ~ #
>
> <pg96_perf_report_4.6.txt.gz>
> <pg95_perf_report_4.6.txt.gz>
> <pg94_perf_report_4.6.txt.gz>
Andres, is there any chance that you would find time to look at those results? Are they actually useful?
>
>
>>
>>> 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
>>
>>
>> --
>> Sent via pgsql-hackers mailing list ([email protected] <mailto:[email protected]>)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-hackers <http://www.postgresql.org/mailpref/pgsql-hackers;
>
>
> --
> May the force be with you…
> https://simply.name <https://simply.name/;
--
May the force be with you…
https://simply.name
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: [HACKERS] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox