Getting started with benchmarking | Postgres.FM 110 |

[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try RUclips's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Michael and Nikolay are joined by Melanie Plageman, database internals engineer at Microsoft and major contributor and committer to PostgreSQL, to discuss getting started with benchmarking - how it differs for users and developers of Postgres, how and when it comes up during development, some tools and lessons, as well as what she's working on at the moment.
Here are some links to things they mentioned:
* Melanie Plageman postgres.fm/pe...
* Meanie’s Introduction to Benchmarking With pgbench talk slides postgresql.us/...
* Melanie’s Visualizing Postgres I/O Performance for Development talk recording • Visualizing Postgres I...
* Melanie’s Visualizing Postgres I/O Performance for Development talk slides speakerdeck.co...
* pgbench www.postgresql...
* Mark Callaghan’s blog smalldatum.blo...
* Some of Tomas Vondra’s blog posts www.2ndquadran...
* Some of Andres Freund’s blog posts www.citusdata....
* An example of Alexander Lakhin’s work www.postgresql...
* Simplifying the TPC Benchmark C, an OLTP Workload (talk by Mark Wong) • Simplifying the TPC Be...
* Matplotlib matplotlib.org/
* pandas pandas.pydata....
* pg_stat_io www.postgresql...
* pg_stat_io commit git.postgresql...
* pg_buffercache www.postgresql...
* tmpfs docs.kernel.or...
* Eager page freeze criteria mailing list thread www.postgresql...
* The path to using AIO in Postgres (talk by Andres Freund) • Andres Freund: The pat...
* Improve dead tuple storage for lazy vacuum (Masahiko Sawada) www.postgresql...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm / postgresfm , @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is produced by:
- Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
- Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the video version. Check out postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.