PostgreSQL High Performance Tuning Guide

PostgreSQL is one of the most powerful and easy–to–use database management systems. It has strong support from the community and is being actively developed with a new release every year.

PostgreSQL supports the most advanced features included in SQL standards. It also provides NoSQL capabilities and very rich data types and extensions. All of this makes PostgreSQL a very attractive solution in software systems.

However, getting the best performance from it has not been an easy subject to tackle. You need just the right combination of rules of thumb to get started, proper testing, solid monitoring, and maintenance to keep your system running well, and hints for add–on tools to add the features the core database doesn’t try to handle on its own.

This Udemy course is structured to give you both the theoretical and practical aspects to implement a High–Performance Postgres. It will help you build dynamic database solutions for enterprise applications using one of the latest releases of PostgreSQL 12.

You’ll examine all the advanced aspects of PostgreSQL 12 in detail, including logical replication, database clusters, performance tuning, and monitoring. You will also work with the PostgreSQL optimizer, configure Postgres for high speed by looking at transactions, locking, indexes, and optimizing queries.