Ebook: Mastering PostgreSQL 11: Expert Techniques to Build Scalable, Reliable, and Fault-Tolerant Database Applications

This book includes the newly introduced features in PostgreSQL 11, and shows you how to build better PostgreSQL applications, and administer your PostgreSQL database efficiently. You will master the advanced features of PostgreSQL and acquire the necessary skills to build efficient database solutions.;Cover; Title Page; Copyright and Credits; About Packt; Contributors; Table of Contents; Preface; Chapter 1: PostgreSQL Overview; What is new in PostgreSQL 11.0?; Understanding the new database administration functions; Using configurable WAL-segment sizes; Larger queryid in pg_stat_statements; Improved indexing and better optimization; Expression index statistics; INCLUDE indexes or covering indexes; Parallel index creation; Better cache management; Improving pg_prewarm; Enhancing windowing functions; Introducing just-in-time compilation; Enhanced partitioning