Overview
Pinned:
Posts for 2020:
Benchmark reports for 2022:
- Insert Benchmark on Beelink (AMD, 8-core, 16G RAM, NVMe)
- Cached by DBMS, 20M rows
- IO-bound, 500m rows
- Insert Benchmark on AWS c7g.2xl with io2 SSD (256G, 10K IOPs)
- Insert Benchmark on AWS c6i.2xl with io2 SSD (256G, 10K IOPs)
- Insert Benchmark on AWS c7g.4xl with io2 SSD (1T, 32K IOPs)
- Insert Benchmark on AWS c6i.4xl with io2 SSD (1T, 32K IOPs)
- Insert Benchmark on AWS c7g.8xl with io2 SSD (2T, 64K IOPs)
- Insert Benchmark on AWS c6i.8xl with io2 SSD (2T, 64K IOPs)
- Insert Benchmark on AWS c7g.16xl with io2 SSD (5T, 100K IOPs)
- Insert Benchmark on AWS c6i.16xl with io2 SSD (5T, 64K IOPs)
- Insert Benchmark
- Insert Benchmark to test wal_compression in Postgres 15
- Insert Benchmark for Postgres 12.11, 13.7, 14.3 and 15beta
- Intel NUC, IO-bound
- Intel NUC, IO-bound, uses prepared statements
- Intel NUC, IO-bound, uses prepared statements, 15b1 with patch 1
- Intel NUC, IO-bound, uses prepared statements, 15b1 with patch 1, larger WAL
- Intel NUC, IO-bound, uses prepared statements, larger WAL, includes 15beta
- Intel NUC, not IO-bound
- Intel NUC, not IO-bound, uses prepared statements
- Intel NUC, not IO-bound, uses prepared statements, 15b1 with patch 1
- Intel NUC, not IO-bound, uses prepared statements, 15b1 with patch 1, larger WAL
- Intel NUC, IO-bound, uses prepared statements, larger WAL, includes 15beta
- Insert Benchmark for Postgres 14.0, 14.1, 14.2, 14.3
Benchmark reports for 2021:
- November
- Insert benchmark, Intel NUC, 1 user, 20M rows (in memory)
- Insert benchmark, Intel NUC, 1 user, 500M rows (IO-bound)
- January, Intel NUC
Benchmark reports for 2020:
- Insert benchmark tests with a table per user
- Insert benchmark tests with 1 table shared by all users
- Linkbench
- Insert benchmark on NUC to determine the best configuration