Understanding system internals and the importance of benchmarking

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