Nikolay and Michael discuss benchmarking — reasons to do it, and some approaches, tools, and resources that can help.

Here are links to a few things we mentioned:

Towards Millions TPS (blog post by Alexander Korotkov)
Episode on testing
Episode on buffers
pgbench
sysbench
Improving Postgres Connection Scalability (blog post by Andres Freund)
pgreplay
pgreplay-go
JMeter
pg_qualstats
pg_query
Database experimenting/benchmarking (talk by Nikolay, 2018)
Database testing (talk by Nikolay at PGCon, 2022)
Systems Performance (Brendan Gregg’s book, chapter 12)
fio
Netdata
Subtransactions Considered Harmful (blog post by Nikolay including Netdata exports)
WAL compression benchmarks (by Vitaly from Postgres.ai)
Dumping/restoring a 1 TiB database benchmarks (by Vitaly from Postgres.ai)
PostgreSQL on EXT3/4, XFS, BTRFS and ZFS (talk slides from Tomas Vondra)
Insert benchmark on ARM and x86 cloud servers (blog post by Mark Callaghan)

------------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.

If you would like to share this episode, here's a good link (and thank you!)

Postgres FM is brought to you by:

Nikolay Samokhvalov, founder of Postgres.ai
Michael Christofides, founder of pgMustard

With special thanks to:

Jessie Draws for the amazing artwork

Brian Tracy: How to be Successful

Motiv8 - The Motivation Podcast and Inspiration Podcast

Refuse to Consider Failure

The AI-powered Podcast Player