Benchmarking | Postgres.FM 032 |

Michael and Nikolay discuss benchmarking - reasons to do it, and some approaches, tools, and resources that can help.
Here are links to a few things we mentioned:
* PostgreSQL Scalability: Towards Millions TPS (blog post by Alexander Korotkov) akorotkov.github.io/blog/2016...
* Episode on using BUFFERS postgres.fm/episodes/buffers-...
* pgbench www.postgresql.org/docs/curre...
* sysbench github.com/akopytov/sysbench
* Improving Postgres Connection Scalability (blog post by Andres Freund) techcommunity.microsoft.com/t...
* pgreplay github.com/laurenz/pgreplay
* pgreplay-go github.com/gocardless/pgrepla...
* JMeter jmeter.apache.org/
* pg_qualstats github.com/powa-team/pg_quals...
* pg_query github.com/pganalyze/libpg_query
* Talk by Nikolay on database experimenting/benchmarking (2018) www.slideshare.net/samokhvalo...
* Talk by Nikolay about database testing (PGCon, 2022) www.pgcon.org/events/pgcon_20...
* Systems Performance (Brendan Gregg’s book, chapter 12) www.brendangregg.com/sysperfb...
* fio github.com/axboe/fio
* Netdata www.netdata.cloud/
* Subtransactions Considered Harmful (blog post by Nikolay including Netdata exports) postgres.ai/blog/20210831-pos.... Benchmark (raw data) by the Postgres.ai team: gitlab.com/postgres-ai/postgr...
* WAL compression benchmarks (raw data) by the Postgres.ai team: gitlab.com/postgres-ai/postgr...
* Dumping/restoring a 1 TiB database, benchmarks (raw data) by the Postgres.ai team gitlab.com/postgres-ai/postgr...
* PostgreSQL on EXT3/4, XFS, BTRFS and ZFS (talk slides from Tomas Vondra) blog.pgaddict.com/pdf/filesys...
* Insert benchmark on ARM and x86 cloud servers (blog post by Mark Callaghan) smalldatum.blogspot.com/2023/...
-------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
~~~
This is the uncut version, with video. Check out Postgres.fm to find audio-only podcast episodes, edited for convenient listening.

[@professortrog7742]

A pg_replay workload on a restored database-image is the fairest comparison between 2 situations. Collection of the workload can indeed be challenging, i will be experimenting with a logging replica.