public inbox for [email protected]  

help / color / mirror / Atom feed

From: Andres Freund <[email protected]>
To: Антон Бушмелев <[email protected]>
Cc: Vladimir Borodin <[email protected]>
Cc: [email protected]
Subject: Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6
Date: Thu, 9 Jun 2016 15:28:56 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

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


-- 
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

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: 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