The 7 Deadly PostgreSQL Mistakes and New Features in PostgreSQL 14

Discover common PostgreSQL pitfalls and explore the latest features in PostgreSQL 14 in this 35-minute Linux Foundation presentation. Learn about the seven most critical mistakes in PostgreSQL implementation, including tool selection, security vulnerabilities, vacuum issues, poor connection management, and suboptimal default settings. Gain insights into proper indexing strategies, extension usage, backup procedures, and design considerations. Then, delve into the PostgreSQL 14 upgrade, examining performance improvements, new data types and functions, vacuum enhancements, standby improvements, and security updates. Understand potential problems and additional updates to make informed decisions about your PostgreSQL deployments.

Introduction
Who are we
Where we see the most issues
Tool selection
Security
Vacuum
Poor Connection Management
Default Settings
Wall Settings
Indexing
Extensions
Backups
Bad Design
PostgreSQL 14 Upgrade
Performance Improvements
Data Types and Functions
Vacuum Enhancements
Standby Enhancements
Security Enhancements
Additional Updates
Potential Problems