Book Image

Mastering PostgreSQL 15 - Fifth Edition

By : Hans-Jürgen Schönig
Book Image

Mastering PostgreSQL 15 - Fifth Edition

By: Hans-Jürgen Schönig

Overview of this book

Starting with an introduction to the newly released features of PostgreSQL 15, this updated fifth edition will help you get to grips with PostgreSQL administration and how to build dynamic database solutions for enterprise apps, including designing both physical and technical aspects of the system. You'll explore advanced PostgreSQL features, such as logical replication, database clusters, advanced indexing, and user management to manage and maintain your database. You'll then work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and move from Oracle to PostgreSQL. Among the other skills that the book will help you build, you’ll cover transactions, handling recursions, working with JSON and JSONB data, and setting up a Patroni cluster. It will show you how to improve performance with query optimization. You'll also focus on managing network security and work with backups and replication while exploring useful PostgreSQL extensions that optimize the performance of large databases. By the end of this PostgreSQL book, you’ll be able to use your database to its utmost capacity by implementing advanced administrative tasks with ease.
Table of Contents (16 chapters)

PostgreSQL 15 Overview

A full year has passed and the PostgreSQL community has released version 15 of the database, which includes various powerful new features that will benefit a large user base. The PostgreSQL project has also come a long way and improvements are being added constantly at a rapid pace that make the database more useful, more efficient, and more widely accepted. The times when PostgreSQL was some unknown obscure thing are long gone. PostgreSQL has reached the data center and has been widely adopted in many large companies as well as by governments around the world.

In this chapter, you will learn about new features that made it into PostgreSQL 15. Those features add additional capabilities, more performance, as well as security and enhanced usability.

The following topics are covered in this chapter:

  • DBA-related features
  • Developer-related features
  • Performance-related features
  • Additional replication features

Of course, there is always...