{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Benchmarking","html":"","width":"100%","height":180,"duration":2206,"description":"Nikolay and Michael discuss benchmarking — reasons to do it, and some approaches, tools, and resources that can help.\n \nHere are links to a few things we mentioned: \nTowards Millions TPS (blog post by Alexander Korotkov)\nEpisode on testing \nEpisode on buffers \npgbench\nsysbench\nImproving Postgres Connection Scalability (blog post by Andres Freund)\npgreplay\npgreplay-go\nJMeter\npg_qualstats\npg_query\nDatabase experimenting/benchmarking (talk by Nikolay, 2018)\nDatabase testing (talk by Nikolay at PGCon, 2022)\nSystems Performance (Brendan Gregg’s book, chapter 12)\nfio\nNetdata\nSubtransactions Considered Harmful (blog post by Nikolay including Netdata exports)\nWAL compression benchmarks (by Vitaly from Postgres.ai)\nDumping/restoring a 1 TiB database benchmarks (by Vitaly from Postgres.ai)\nPostgreSQL on EXT3/4, XFS, BTRFS and ZFS (talk slides from Tomas Vondra)\nInsert benchmark on ARM and x86 cloud servers (blog post by Mark Callaghan)\n\n------------------------\n\nWhat 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.\nIf you would like to share this episode, here's a good link (and thank you!)\n\nPostgres FM is brought to you by:\nNikolay Samokhvalov, founder of Postgres.ai\nMichael Christofides, founder of pgMustard\n\nWith special thanks to:\nJessie Draws for the amazing artwork ","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}