PostgreSQL 12 Overview

After the usual development cycle, PostgreSQL 12 was released to the public in autumn 2019. The new release offers a variety of new features and provides a rich set of functionality to users, which will make application development faster, improve performance, and generally make PostgreSQL even more usable than it previously was. Many of the new features open the door for further development in the future and will enable developers to implement cutting edge technologies in the decades to come. In this chapter, you will be introduced to those new features and will get an overview of what has been improved, added, and even changed.

The following topics will be covered:

• What's new in PostgreSQL 12?
• SQL and developer-related features
• Backup, recovery, and replication
• Performance-related topics
• Storage-related topics

All relevant features will be covered. Of course, there is always more, and thousands of tiny changes have made it into PostgreSQL 12. What you will see in this chapter are the highlights of the new release.