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 shiney 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 Experessions, 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