Update benchmarks authored by Dan Notestein's avatar Dan Notestein
...@@ -209,7 +209,7 @@ Steem-11 ...@@ -209,7 +209,7 @@ Steem-11
test6 test6
</td> </td>
<td>2x2TB 980Pro MD raid noatime; blocklog HDD; shared mem /dev/shm; /var/lib/postgresql noatime</td> <td>2x2TB 980Pro MD raid noatime; blocklog HDD; shared mem hafpool; /var/lib/postgresql noatime</td>
<td>62M</td> <td>62M</td>
<td>zfs nocompr</td> <td>zfs nocompr</td>
<td>N/A</td> <td>N/A</td>
...@@ -248,7 +248,7 @@ test7 ...@@ -248,7 +248,7 @@ test7
</td> </td>
<td> <td>
2x2TB 980Pro MD raid noatime; blocklog HDD; shared mem /dev/shm; /var/lib/postgresql noatime hafpool nocompr, 2x2TB 980Pro MD raid noatime; blocklog HDD; shared mem hafpool; /var/lib/postgresql noatime hafpool nocompr,
full_page_writes=off, wal_init_zero=off, wal_recycle=off full_page_writes=off, wal_init_zero=off, wal_recycle=off
</td> </td>
...@@ -329,7 +329,7 @@ test8 ...@@ -329,7 +329,7 @@ test8
<div> <div>
2x2TB 980Pro zfs raid noatime; blocklog HDD; shared mem /dev/shm; /var/lib/postgresql hafpool nocompr, 2x2TB 980Pro zfs raid noatime; blocklog HDD; shared mem hafpool; /var/lib/postgresql hafpool nocompr,
full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off
...@@ -412,7 +412,7 @@ test9 ...@@ -412,7 +412,7 @@ test9
<div> <div>
2x2TB 980Pro zfs raid noatime; blocklog HDD; shared mem /dev/shm; /var/lib/postgresql hafpool nocompr, 2x2TB 980Pro zfs raid noatime; blocklog HDD; shared mem hafpool; /var/lib/postgresql hafpool nocompr,
full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off, zfs_arc_max-modified(32GB) full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off, zfs_arc_max-modified(32GB)
...@@ -506,7 +506,7 @@ test10 ...@@ -506,7 +506,7 @@ test10
<div> <div>
2x2TB 980Pro zfs raid noatime; blocklog HDD; shared mem /dev/shm; /var/lib/postgresql hafpool nocompr, 2x2TB 980Pro zfs raid noatime; blocklog HDD; shared mem hafpool; /var/lib/postgresql hafpool nocompr,
full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off (postgreql.conf), zfs_arc_max-modified(32GB) full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=off (postgreql.conf), zfs_arc_max-modified(32GB)
...@@ -559,7 +559,7 @@ test11 ...@@ -559,7 +559,7 @@ test11
<div> <div>
2x2TB 980Pro zfs raid noatime; blocklog HDD; shared mem /dev/shm; /var/lib/postgresql hafpool nocompr, 2x2TB 980Pro zfs raid noatime; blocklog HDD; shared mem hafpool; /var/lib/postgresql hafpool nocompr,
full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=on(postgreql.conf) full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=on(postgreql.conf)
...@@ -618,7 +618,7 @@ test12 ...@@ -618,7 +618,7 @@ test12
<div> <div>
2x2TB 980Pro zfs raid noatime; blocklog HDD; shared mem /dev/shm; /var/lib/postgresql hafpool nocompr, 2x2TB 980Pro zfs raid noatime; blocklog HDD; shared mem hafpool; /var/lib/postgresql hafpool nocompr,
full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=on(postgreql.conf) full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=on(postgreql.conf)
...@@ -680,7 +680,7 @@ test12 ...@@ -680,7 +680,7 @@ test12
</div></td> </div></td>
<td> <td>
**4x2TB** 980Pro zfs raid noatime; blocklog HDD; shared mem /dev/shm; /var/lib/postgresql noatime, hafpool nocompr, **4x2TB** 980Pro zfs raid noatime; blocklog HDD; shared mem hafpool; /var/lib/postgresql noatime, hafpool nocompr,
full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=on(postgreql.conf) full_page_writes=off, wal_init_zero=off, wal_recycle=off, fsync=on(postgreql.conf)
...@@ -740,7 +740,7 @@ test13 ...@@ -740,7 +740,7 @@ test13
<div> <div>
**4x2TB** 980Pro zfs raid noatime; blocklog HDD; shared mem /dev/shm; /var/lib/postgresql noatime, hafpool nocompr, **4x2TB** 980Pro zfs raid noatime; blocklog HDD; shared mem hafpool; /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)
...@@ -842,7 +842,7 @@ test14 ...@@ -842,7 +842,7 @@ test14
<div> <div>
**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 hafpool; /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)
...@@ -915,7 +915,7 @@ Test15 ...@@ -915,7 +915,7 @@ Test15
<div> <div>
**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 hafpool; /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)
... ...
......