PostgreSQL Performance - 20 years of improvements

Let's do some basic benchmarks (both OLTP and OLAP) on releases since PostgreSQL 8.0, and see how the performance changed over the years. It's unexpectedly difficult to realize how much has the performance 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 about how to use cool new features during this talk, but hopefully you'll learn how far we got in the past ~20 years.