Performance Archaeology

20 years of improvements

Video of a conference talk outlining some basic benchmarks (both OLTP and OLAP) on releases since PostgreSQL 8.0, and how the performance has changed over the years. It's unexpectedly difficult to realize how much the performance has changed over many releases, because we usually test and measure only the two releases. But the incremental improvements can compound pretty quickly, and the hardware and applications change too. So, let's do some testing and look at numbers ;-) You will not learn how to use cool new features during this talk, but hopefully you'll learn how far we’ve gotten in the past ~20 years. Tomas Vondra is a long-term PostgreSQL contributor and committer, focusing on performance, query planning and optimization, etc. In addition, Tomas is a principal software engineer at Microsoft working on Postgres. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 01:39 Why do this at all? ⏩ 05:38 Hardware overview ⏩ 07:38 OLTP benchmarks ⏩ 14:03 OLTP starjoin benchmarks ⏩ 19:19 OLTP summary and future ⏩ 20:30 OLAP benchmarks ⏩ 25:55 OLAP summary & future ⏩ 26:42 The future: what might happen? ⏩ 28:32 Resources and conclusion Resources: http://www.postgresql.eu/events/pgconfeu2024/schedule/session/5839-numa-vs-postgresql/ tomas@vondra.me 📕 Everything you need to know about POSETTE: An Event for Postgres 2025 can be found at: https://posetteconf.com ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist 📌 Let’s connect:   LinkedIn - https://www.linkedin.com/company/posetteconf/ X – @PosetteConf, https://twitter.com/PosetteConf Mastodon – @posetteconf, https://mastodon.social/@posetteconf Bluesky – @posetteconf.com, https://bsky.app/profile/posetteconf.com __________________________________ #PosetteConf #PostgreSQL #Performance