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

2016-07-15 Thread Dmitriy Sarafannikov
>I don't really see anything suspicious in the profile. This looks more >like a kernel scheduler issue than a postgres bottleneck one. It seems >that somehow using nonblocking IO (started in 9.5) causes scheduling >issues when pgbouncer is also local. > >Could you do perf stat -ddd -a sleep 10 or

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

2016-07-14 Thread Andres Freund
On 2016-07-04 16:30:51 +0300, Vladimir Borodin wrote: > > > 13 июня 2016 г., в 21:58, Vladimir Borodin написал(а): > > > >> > >> 13 июня 2016 г., в 0:51, Andres Freund >> > написал(а): > >> > >> Hi Vladimir, > >> > >> Thanks for these reports. > >> > >> On 2016-06-13 00

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

2016-07-14 Thread Andres Freund
On 2016-06-13 21:58:30 +0300, Vladimir Borodin wrote: > > > 13 июня 2016 г., в 0:51, Andres Freund написал(а): > > > > 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 >

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

2016-07-04 Thread Vladimir Borodin
> 13 июня 2016 г., в 21:58, Vladimir Borodin написал(а): > >> >> 13 июня 2016 г., в 0:51, Andres Freund > > написал(а): >> >> Hi Vladimir, >> >> Thanks for these reports. >> >> On 2016-06-13 00:42:19 +0300, Vladimir Borodin wrote: >>> perf report -g -i pg9?_all.dat