Postgres Pro
Downloads
Home   >   mailing lists

Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 - Mailing list pgsql-performance

From Andres Freund
Subject Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
Date
Msg-id 20160609222855.irpszcpo6qn4skq2@alap3.anarazel.de
Whole thread Raw
In response to Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6  (Антон Бушмелев <bushmelev.aa@gmail.com>)
List pgsql-performance
Tree view 
Hi,

On 2016-06-02 14:18:26 +0300, Антон Бушмелев wrote:
> UP. repeat tests on local vm.. reults are discouraging
> OS             PG        TPS         AVG latency
> Centos 7     9.5.3     23.711023     168.421
> Centos 7     9.5.3     26.609271     150.188
> Centos 7     9.5.3     25.220044     158.416
> Centos 7     9.5.3     25.598977     156.047
> Centos 7     9.4.8     278.572191     14.077
> Centos 7     9.4.8     247.237755     16.177
> Centos 7     9.4.8     240.007524     16.276
> Centos 7     9.4.8     237.862238     16.596

Could you provide profiles on 9.4 and 9.5?  Which kernel did you have
enabled? Is /proc/sys/kernel/sched_autogroup_enabled 1 or 0?

Regards,

Andres

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: array size exceeds the maximum allowed (1073741823) when building a json
Next
From: Rowan Seymour
Date:
Subject: Many-to-many performance problem