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

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
Дата
Msg-id 20160612215140.znmnl4mpzvgxjmgn@alap3.anarazel.de
обсуждение исходный текст
Ответы Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6  (Vladimir Borodin <root@simply.name>)
Список 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 по дате отправления:

Предыдущее
От: Ioseph Kim
Дата:
Сообщение: increase message string buffer size of watch command of psql
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Confusing recovery message when target not hit