Changes

Page history
Update benchmarks authored by Logan DeHart's avatar Logan DeHart
Hide whitespace changes
Inline Side-by-side
benchmarks.md
View page @ 7ec9f650
...@@ -422,14 +422,8 @@ full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off, zfs_arc_max ...@@ -422,14 +422,8 @@ full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off, zfs_arc_max
<td> <td>
</td> </td>
<td> <td>10hr+5.3hr reindex</td>
10hr+5.3hr reindex <td>summary=20004 in 00:06:59=47.8/s Avg:208 Min:18 Max:5230 summary=20004 in 00:05:56=56.2/s Avg:175 Min:18 Max:4872 wal_compr_summary=20004 in 00:05:22=62.2/s Avg:158 Min:18 Max:3817</td>
</td>
<td>
summary=20004 in 00:06:59=47.8/s Avg:208 Min:18 Max:5230
summary=20004 in 00:05:56=56.2/s Avg:175 Min:18 Max:4872
wal_compr_summary=20004 in 00:05:22=62.2/s Avg:158 Min:18 Max:3817
</td>
</tr> </tr>
<tr> <tr>
<td> <td>
...@@ -444,14 +438,8 @@ test10 ...@@ -444,14 +438,8 @@ test10
<td> <td>
</td> </td>
<td> <td>9.47hr+6.25hr reindex</td>
9.47hr+6.25hr reindex <td>summary=20004 in 00:05:52=56.8/s Avg:173 Min:18 Max:3690 summary=20004 in 00:05:56=56.2/s Avg:175 Min:18 Max:4872 wal_compr_summary=20004 in 00:04:25=75.6/s Avg:130 Min:19 Max:3814</td>
</td>
<td>
summary=20004 in 00:05:52=56.8/s Avg:173 Min:18 Max:3690
summary=20004 in 00:05:56=56.2/s Avg:175 Min:18 Max:4872
wal_compr_summary=20004 in 00:04:25=75.6/s Avg:130 Min:19 Max:3814
</td>
</tr> </tr>
<tr> <tr>
<td> <td>
...@@ -462,19 +450,13 @@ test10 ...@@ -462,19 +450,13 @@ test10
</td> </td>
<td>2x2TB XtPro(/xtpool) zfs raid; shared mem /dev/shm, /var/lib/postgresql/xt-pool, noatime, full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off</td> <td>2x2TB XtPro(/xtpool) zfs raid; shared mem /dev/shm, /var/lib/postgresql/xt-pool, noatime, full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off</td>
<td>62M</td> <td>62M</td>
<td>ZFS lz4: compr=???</td> <td>ZFS lz4: compr=2.09x</td>
<td> <td>
</td> </td>
<td> <td>10.44hr+5.93hr reindex</td>
10.44hr+5.93hr reindex <td>summary=20004 in 00:09:20=35.7/s Avg:275 Min:16 Max:5077 summary=20004 in 00:07:07=46.9/s Avg:211 Min:17 Max:5543</td>
</td>
<td>
summary=20004 in 00:09:20=35.7/s Avg:275 Min:16 Max:5077
summary=20004 in 00:07:07=46.9/s Avg:211 Min:17 Max:5543
</td>
</tr> </tr>
<tr> <tr>
<td> <td>
...@@ -482,22 +464,19 @@ Shed14 ...@@ -482,22 +464,19 @@ Shed14
test10 test10
</td> </td>
<td>2x2TB XtPro(/xtpool) zfs raid; shared mem /dev/shm, /var/lib/postgresql/xt-pool, noatime, full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off <td>
2x2TB XtPro(/xtpool) zfs raid; shared mem /dev/shm, /var/lib/postgresql/xt-pool, noatime, full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off
psql-track-operations = custom_json_operation psql-track-operations = custom_json_operation psql-track-body-operations = \["custom_json_operation","sm\_.\*"\]
psql-track-body-operations = ["custom_json_operation","sm_.*"]
</td> </td>
<td>62M</td> <td>62M</td>
<td>ZFS lz4</td> <td>ZFS lz4</td>
<td>359G (288G operations, 191G transactions, 48G account_operations)</td>
<td>11.1hr+1.1hr reindex</td>
<td> <td>
359G (288G operations, 191G transactions, 48G account_operations)
</td>
<td>
11.1hr+1.1hr reindex
</td>
<td>
</td> </td>
</tr> </tr>
</table> </table>