Postgres Pro
Downloads
Home   >   mailing lists

Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? - Mailing list pgsql-performance

From Saurabh Nanda
Subject Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"?
Date
Msg-id CAPz=2oEN1DRjhWLJNN112xO-vzSGff=Cqgs5oLw9W12y=NMtWw@mail.gmail.com
Whole thread Raw
In response to Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"?  (Saurabh Nanda <saurabhnanda@gmail.com>)
Responses Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"?  (Saurabh Nanda <saurabhnanda@gmail.com>)
List pgsql-performance
Tree view
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       |
+--------+--------------+----------------+----------------+-----------------+

pgsql-performance by date:

Previous
From: Saurabh Nanda
Date:
Subject: Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"?
Next
From: Saurabh Nanda
Date:
Subject: Re: Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"?