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
Overview
Syllabus
Intro
Postgres 11 vs 12
TwoDate function
TwoDate example
oids removed
No ID column
Foreign key naming
Full text search languages
Common materialized expressions
Simple query
Performance benefits
Random page costs
Forced plan cash mode
Prepare a query
Force generic plan
Reindex
Reindex concurrently
Create replace aggregates
Postgres Progress Vacuum
Postgres Cluster
Create Index
System Views
Storage Engines
Index Methods
Command Line Tools
Temp Socket
csv
pgpromote
multivariate column statistics
Taught by
Linux Foundation
