Welcome to Postgres 12

PostgreSQL 12 is focused on performance and optimization. This release wasn’t built with brand-new, shiny features in mind; instead, it’s a finely-tuned, well-polished implementation of existing PostgreSQL capabilities. Because new versions of PostgreSQL are released every year, not every new feature is fully capable when it is introduced. After a couple of releases, when the feature has had a chance to grow from its initial implementation, its performance becomes polished, edge cases become supported, and missing capabilities get implemented. Some releases are all about shiny new features, and that hype cycle makes them easy to advocate for. But Postgres 12 is a more subtle release; focused on performance and optimization. Yes, there are some shiny new features (JSONPath anyone?), but even better, this release ups the game for many of the features that got headlines the last few release cycles, providing a more polished experience for PostgreSQL's many capabilities. Join me as we take a look at some of my favorite changes that will make your life better, like improvements to Common Table Expressions, B-Tree index improvements, and better partitioning support, in this latest and greatest version of Postgres. SQL from demo : https://gist.github.com/xzilla/6e5358212ece1ccd29549bab4d878801 Presented at SCaLE 18x