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:
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
