Explore the new features and improvements in PostgreSQL 12 through a series of hands-on demonstrations. Dive into enhancements like the TwoDate function, oids removal, foreign key naming, full-text search languages, and common materialized expressions. Learn about performance optimizations including random page costs, forced plan cache mode, and concurrent reindexing. Discover updates to system views, storage engines, index methods, and command-line tools. Gain practical insights into PostgreSQL 12's capabilities through this comprehensive, demo-driven conference talk by Robert Treat from credativ, presented at a Linux Foundation event.
PostgreSQL 12: New Features and Improvements - All Demos Edition