Services
24×7×365 Technical Support
Migration to PostgreSQL
High Availability Deployment
Database Audit
Remote DBA for PostgreSQL
Products
Postgres Pro Enterprise
Postgres Pro Standard
Cloud Solutions
Postgres Extensions
Resources
Blog
Documentation
Webinars
Videos
Presentations
Community
Events
Training Courses
Books
Demo Database
Mailing List Archives
About
Leadership team
Partners
Customers
In the News
Press Releases
Press Info
Services
24×7×365 Technical Support
Migration to PostgreSQL
High Availability Deployment
Database Audit
Remote DBA for PostgreSQL
Products
Postgres Pro Enterprise
Postgres Pro Standard
Cloud Solutions
Postgres Extensions
Resources
Blog
Documentation
Webinars
Videos
Presentations
Community
Events
Training Courses
Books
Demo Database
Mailing List Archives
About
Leadership team
Partners
Customers
In the News
Press Releases
Press Info
Facebook
Downloads
Home
>
mailing lists
Re: Perf Benchmarking and regression. - Mailing list pgsql-hackers
From
Mithun Cy
Subject
Re: Perf Benchmarking and regression.
Date
May 6, 2016
18:51:19
Msg-id
CAD__OuiObzNVTt_hO__P5AEnU4iNqcFWgArXR4TbLKe-UXyukQ@mail.gmail.com
Whole thread
Raw
In response to
Re: Perf Benchmarking and regression.
(Andres Freund <andres@anarazel.de>)
Responses
Re: Perf Benchmarking and regression.
(Andres Freund <andres@anarazel.de>)
List
pgsql-hackers
Tree view
On Fri, May 6, 2016 at 8:35 PM, Andres Freund
<
andres@anarazel.de
>
wrote:
> Also, do you see read-only workloads to be affected too?
Thanks, I have not tested with above specific commitid which reported performance issue but
At HEAD commit 72a98a639574d2e25ed94652848555900c81a799
Author: Andres Freund <
andres@anarazel.de
>
Date: Tue Apr 26 20:32:51 2016 -0700
READ-Only (prepared) tests (both when data fits to shared buffers or it exceeds shared buffer=8GB) performance of master has improved over 9.5
Sessions
PostgreSQL-9.5 scale 300
PostgreSQL-9.6 scale 300
%diff
1
5287.561594
5213.723197
-1.396454598
8
84265.389083
84871.305689
0.719057507
16
148330.4155
158661.128315
6.9646624936
24
207062.803697
219958.12974
6.2277366155
32
265145.089888
290190.501443
9.4459269699
40
311688.752973
340000.551772
9.0833559212
48
327169.9673
372408.073033
13.8270960829
56
274426.530496
390629.24948
42.3438356248
64
261777.692042
384613.9666
46.9238893505
72
210747.55937
376390.162022
78.5976374517
80
220192.818648
398128.779329
80.8091570713
88
185176.91888
423906.711882
128.9198429512
96
161579.719039
421541.656474
160.8877271115
104
146935.568434
450672.740567
206.7145316618
112
136605.466232
432047.309248
216.2738074582
120
127687.175016
455458.086889
256.6983816753
128
120413.936453
428127.879242
255.5467845776
Sessions
PostgreSQL-9.5 scale 1000
PostgreSQL-9.6 scale 1000
%diff
1
5103.812202
5155.434808
1.01145191
8
47741.9041
53117.805096
11.2603405694
16
89722.57031
86965.10079
-3.0733287182
24
130914.537373
153849.634245
17.5191367836
32
197125.725706
212454.474264
7.7761279017
40
248489.551052
270304.093767
8.7788571482
48
291884.652232
317257.836746
8.6928806705
56
304526.216047
359676.785476
18.1102862489
64
301440.463174
388324.710185
28.8230206709
72
194239.941979
393676.628802
102.6754254511
80
144879.527847
383365.678053
164.6099719885
88
122894.325326
372905.436117
203.4358463076
96
109836.31148
362208.867756
229.7715144249
104
103791.981583
352330.402278
239.4582094921
112
105189.206682
345722.499429
228.6672752217
120
108095.811432
342597.969088
216.939171416
128
113242.59492
333821.98763
194.7848270925
Even for READ-WRITE when data fits into shared buffer (scale_factor=300 and shared_buffers=8GB) performance has improved.
Only case is when data exceeds shared_buffer(scale_factor=1000 and shared_buffers=8GB) I see some regression.
I will try to run the tests as you have suggested and will report the same.
Thanks and Regards
Mithun C Y
EnterpriseDB:
http://www.enterprisedb.com
pgsql-hackers
by date:
Previous
From:
Vladimir Gordiychuk
Date:
06 May 2016, 18:23:50
Subject:
Stopping logical replication protocol
Next
From:
Robert Haas
Date:
06 May 2016, 19:10:21
Subject:
Re: SET ROLE and reserved roles
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
I confirm that I have read and accepted PostgresPro’s
Privacy Policy
.
I agree to get Postgres Pro discount offers and other marketing communications.
✖
×
×
Everywhere
Documentation
Mailing list
List:
all lists
pgsql-general
pgsql-hackers
buildfarm-members
pgadmin-hackers
pgadmin-support
pgsql-admin
pgsql-advocacy
pgsql-announce
pgsql-benchmarks
pgsql-bugs
pgsql-chat
pgsql-cluster-hackers
pgsql-committers
pgsql-cygwin
pgsql-docs
pgsql-hackers-pitr
pgsql-hackers-win32
pgsql-interfaces
pgsql-jdbc
pgsql-jobs
pgsql-novice
pgsql-odbc
pgsql-patches
pgsql-performance
pgsql-php
pgsql-pkg-debian
pgsql-pkg-yum
pgsql-ports
pgsql-rrreviewers
pgsql-ru-general
pgsql-sql
pgsql-students
pgsql-testers
pgsql-translators
pgsql-www
psycopg
Period
anytime
within last day
within last week
within last month
within last 6 months
within last year
Sort by
date
reverse date
rank
Services
24×7×365 Technical Support
Migration to PostgreSQL
High Availability Deployment
Database Audit
Remote DBA for PostgreSQL
Products
Postgres Pro Enterprise
Postgres Pro Standard
Cloud Solutions
Postgres Extensions
Resources
Blog
Documentation
Webinars
Videos
Presentations
Community
Events
Training Courses
Books
Demo Database
Mailing List Archives
About
Leadership team
Partners
Customers
In the News
Press Releases
Press Info
By continuing to browse this website, you agree to the use of cookies. Go to
Privacy Policy
.
I accept cookies