Cover image for Mastering PostgreSQL 15

Mastering PostgreSQL 15

Advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications

HS

Created by Hans-Jürgen Schönig

Explore advanced PostgreSQL 15 features and learn how to design, manage, and optimize enterprise-grade databases. Get hands-on with real-world scenarios that cover everything from performance tuning to high availability. Build confidence in handling complex administrative tasks and scaling your database systems.

Packt | Jan 2023 | 522 min

What You Will Learn

You will work through practical examples and scenarios that mirror real enterprise needs. Each topic builds on your existing knowledge, guiding you through advanced configuration, optimization, and troubleshooting. By applying these techniques, you will develop the confidence to manage and scale PostgreSQL databases effectively.

Key Features

  • Optimize query performance and indexing for faster, more efficient databases
  • Set up replication, failover, and clustering to boost reliability and uptime
  • Strengthen security and manage backups to protect and recover your data

Target Audience

Ideal for database administrators and developers who already understand PostgreSQL basics and want to deepen their expertise. If you are looking to implement advanced features, improve performance, or handle complex migrations, you will find practical guidance and actionable strategies to reach your goals.

Related courses