| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Антон Бушмелев <bushmelev(dot)aa(at)gmail(dot)com> |
| Cc: | Vladimir Borodin <root(at)simply(dot)name>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 |
| Date: | 2016-06-09 22:28:56 |
| Message-ID: | 20160609222855.irpszcpo6qn4skq2@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2016-06-09 23:16:13 | Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < |
| Previous Message | Robert Haas | 2016-06-09 22:11:07 | Re: Rename max_parallel_degree? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rowan Seymour | 2016-06-10 13:04:01 | Many-to-many performance problem |
| Previous Message | Merlin Moncure | 2016-06-09 20:36:21 | Re: array size exceeds the maximum allowed (1073741823) when building a json |