Changes
Page history
Update benchmarks
authored
Apr 29, 2022
by
Logan DeHart
Show whitespace changes
Inline
Side-by-side
benchmarks.md
View page @
b54739f1
...
...
@@ -775,6 +775,8 @@ Test 12
ZFS zstd:
compr=3.07x
(Ubuntu 22.04LTS, Postgresql14)
</td>
<td>
1TB(1007GB) including blocklog
</td>
<td>
12.9Hr+8.9Hr to reindex
</td>
...
...
@@ -794,7 +796,12 @@ Test 13
</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>
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>
10.9Hr+8Hr to reindex
</td>
<td>
...
...
@@ -869,7 +876,12 @@ Test14
</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>
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>
10.58Hr+6Hr to reindex
</td>
<td>
...
...
@@ -893,12 +905,15 @@ zfs sync=disabled, psql TOAST compr=lz4
</div></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>
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>
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>
<td>
...
...
@@ -913,13 +928,16 @@ Test15
**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)
zfs sync=disabled
full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off(postgreql.conf)zfs sync=disabled
</div></td>
<td>
62M
</td>
<td>
ZFS zstd-19: compr=???
</td>
<td>
ZFS zstd-19: compr=???
(Ubuntu 22.04LTS, Postgresql14)
</td>
<td>
</td>
...
...
@@ -939,11 +957,64 @@ Test15
</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 zstd-fast: compr=?
</td>
<td>
ZFS zstd-fast: compr=?
(Ubuntu 22.04LTS, Postgresql14)
</td>
<td>
747GB+305GB blocklog
</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>
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>
</tr>
</table>
...
...
...
...