Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Linux Foundation

The 7 Deadly PostgreSQL Mistakes and New Features in PostgreSQL 14

Linux Foundation via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.

Syllabus

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

Taught by

Linux Foundation

Reviews

Start your review of The 7 Deadly PostgreSQL Mistakes and New Features in PostgreSQL 14

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.