Update benchmarks authored by Logan DeHart's avatar Logan DeHart
...@@ -775,6 +775,8 @@ Test 12 ...@@ -775,6 +775,8 @@ Test 12
ZFS zstd: ZFS zstd:
compr=3.07x compr=3.07x
(Ubuntu 22.04LTS, Postgresql14)
</td> </td>
<td>1TB(1007GB) including blocklog</td> <td>1TB(1007GB) including blocklog</td>
<td>12.9Hr+8.9Hr to reindex</td> <td>12.9Hr+8.9Hr to reindex</td>
...@@ -794,7 +796,12 @@ Test 13 ...@@ -794,7 +796,12 @@ Test 13
</div></td> </div></td>
<td>2x2TB XtPro(/xtpool) zfs raid noatime; shared mem in /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 noatime; shared mem in /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 zstd: compr=3.06x</td> <td>
ZFS zstd: compr=3.06x
(Ubuntu 22.04LTS, Postgresql14)
</td>
<td>695GB+314GB for blocklog</td> <td>695GB+314GB for blocklog</td>
<td>10.9Hr+8Hr to reindex</td> <td>10.9Hr+8Hr to reindex</td>
<td> <td>
...@@ -869,7 +876,12 @@ Test14 ...@@ -869,7 +876,12 @@ Test14
</td> </td>
<td>2x2TB XtPro(/xtpool) zfs raid noatime; shared mem in /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 noatime; shared mem in /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 zstd-fast: compr=2.91x</td> <td>
ZFS zstd-fast: compr=2.91x
(Ubuntu 22.04LTS, Postgresql14)
</td>
<td>746GB+314GB for blocklog</td> <td>746GB+314GB for blocklog</td>
<td>10.58Hr+6Hr to reindex</td> <td>10.58Hr+6Hr to reindex</td>
<td> <td>
...@@ -893,12 +905,15 @@ zfs sync=disabled, psql TOAST compr=lz4 ...@@ -893,12 +905,15 @@ zfs sync=disabled, psql TOAST compr=lz4
</div></td> </div></td>
<td>62M</td> <td>62M</td>
<td>ZFS zstd-9: compr=???</td>
<td>653GB+531GB for blocklog</td>
<td>10.6Hr + 7.66Hr to reindex</td>
<td> <td>
summary = 20004 in 00:12:23 = 26.9/s Avg: 368 Min: 14 Max: 10362
ZFS zstd-9: compr=???
(Ubuntu 22.04LTS, Postgresql14)
</td> </td>
<td>653GB+531GB for blocklog</td>
<td>10.6Hr + 7.66Hr to reindex</td>
<td>summary = 20004 in 00:12:23 = 26.9/s Avg: 368 Min: 14 Max: 10362</td>
</tr> </tr>
<tr> <tr>
<td> <td>
...@@ -913,13 +928,16 @@ Test15 ...@@ -913,13 +928,16 @@ Test15
**3x2TB** 980Pro zfs raid noatime; blocklog NVME(Samsung 980); shared mem /dev/shm; /var/lib/postgresql noatime, hafpool nocompr, **3x2TB** 980Pro zfs raid noatime; blocklog NVME(Samsung 980); shared mem /dev/shm; /var/lib/postgresql noatime, hafpool nocompr,
full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off(postgreql.conf) full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off(postgreql.conf)zfs sync=disabled
zfs sync=disabled
</div></td> </div></td>
<td>62M</td> <td>62M</td>
<td>ZFS zstd-19: compr=???</td> <td>
ZFS zstd-19: compr=???
(Ubuntu 22.04LTS, Postgresql14)
</td>
<td> <td>
</td> </td>
...@@ -939,11 +957,64 @@ Test15 ...@@ -939,11 +957,64 @@ Test15
</td> </td>
<td>4x2TB XtPro(/xtpool) zfs raid noatime; shared mem in /dev/shm, /var/lib/postgresql/xt-pool, noatime, full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off</td> <td>4x2TB XtPro(/xtpool) zfs raid noatime; shared mem in /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 zstd-fast: compr=?</td> <td>
ZFS zstd-fast: compr=?
(Ubuntu 22.04LTS, Postgresql14)
</td>
<td>747GB+305GB blocklog</td> <td>747GB+305GB blocklog</td>
<td>10.7Hr+7.9Hr to reindex</td> <td>10.7Hr+7.9Hr to reindex</td>
<td>summary = 20004 in 00:11:41 = 28.5/s Avg: 348 Min: 14 Max: 9304</td>
</tr>
<tr>
<td> <td>
summary = 20004 in 00:11:41 = 28.5/s Avg: 348 Min: 14 Max: 9304
Shed14
Test16
</td>
<td>4x2TB XtPro(/xtpool) zfs raid noatime; shared mem in /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>
ZFS lz4
(Ubuntu 22.04LTS, Postgresql14)
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
Steem-10
Blocklog Compression
</td>
<td>
Compress_block_log
1x2TB nvme (Samsung 980 Pro)
</td>
<td>???</td>
<td>(Ubuntu 22.04LTS, Postgresql14)</td>
<td>
</td>
<td>
</td>
<td>
</td> </td>
</tr> </tr>
</table> </table>
... ...
......