Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?

From: Saurabh Nanda <saurabhnanda(at)gmail(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
Date: 2019-01-28 04:59:41
Message-ID: CAPz=2oEN1DRjhWLJNN112xO-vzSGff=Cqgs5oLw9W12y=NMtWw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Here's the previous table again -- trying to prevent the wrapping.

+--------+------------------------------------------------+-----------------+
| | synchronous_commit=on | sync_commit=off |
+--------+------------------------------------------------+-----------------+
| client | Defaults [1] | Optimised [2] | Optimised [2] | Optimised [2] |
| | | (buffers=2G) | (buffers=8G) | (buffers=8G) |
+--------+--------------+----------------+----------------+-----------------+
| 1 | 80-86 | 74-77 | 75-75 | 169-180 |
+--------+--------------+----------------+----------------+-----------------+
| 6 | 350-376 | 301-304 | 295-300 | 1265-1397 |
+--------+--------------+----------------+----------------+-----------------+
| 12 | 603-619 | 476-488 | 485-493 | 1746-2352 |
+--------+--------------+----------------+----------------+-----------------+
| 24 | 947-1015 | 678-739 | 723-770 | 1869-2518 |
+--------+--------------+----------------+----------------+-----------------+
| 48 | 1435-1512 | 950-1043 | 1029-1086 | 1912-2818 |
+--------+--------------+----------------+----------------+-----------------+
| 96 | 1769-1811 | 3337-3459 | 1302-1346 | 1546-1753 |
+--------+--------------+----------------+----------------+-----------------+
| 192 | 1857-1992 | 3613-3715 | 1269-1345 | 1332-1508 |
+--------+--------------+----------------+----------------+-----------------+
| 384 | 1667-1793 | 3180-3300 | 1262-1364 | 1356-1450 |
+--------+--------------+----------------+----------------+-----------------+

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Saurabh Nanda 2019-01-28 05:03:21 Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
Previous Message Saurabh Nanda 2019-01-28 04:52:17 Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?