Ebook: Mastering PostgreSQL 10: Expert techniques on PostgreSQL 10 development and administration

Cover -- Title Page -- Copyright and Credits -- Packt Upsell -- Contributors -- Table of Contents -- Preface -- Chapter 1: PostgreSQL Overview -- What is new in PostgreSQL 10.0? -- Understanding new database administration functions -- Using additional information in pg_stat_activity -- Introducing SCRAM-SHA-256 -- Improving support for replication -- Understanding logical replication -- Introducing quorum COMMIT -- Partitioning data -- Making use of CREATE STATISTICS -- Improving parallelism -- Introducing ICU encodings -- Summary -- Chapter 2: Understanding Transactions and Locking -- Working with PostgreSQL transactions -- Handling errors inside a transaction -- Making use of SAVEPOINT -- Transactional DDLs -- Understanding basic locking -- Avoiding typical mistakes and explicit locking -- Considering alternative solutions -- Making use of FOR SHARE and FOR UPDATE -- Understanding transaction isolation levels -- Considering SSI transactions -- Observing deadlocks and similar issues -- Utilizing advisory locks -- Optimizing storage and managing cleanup -- Configuring VACUUM and autovacuum -- Digging into transaction wraparound-related issues -- A word on VACUUM FULL -- Watching VACUUM at work -- Making use of snapshot too old -- Summary -- Chapter 3: Making Use of Indexes -- Understanding simple queries and the cost model -- Making use of EXPLAIN -- Digging into the PostgreSQL cost model -- Deploying simple indexes -- Making use of sorted output -- Using more than one index at a time -- Using bitmap scans effectively -- Using indexes in an intelligent way -- Improving speed using clustered tables -- Clustering tables -- Making use of index only scans -- Understanding additional b-tree features -- Combined indexes -- Adding functional indexes -- Reducing space consumption -- Adding data while indexing -- Introducing operator classes.;PostgreSQL is an open source database used for handling large datasets (big data) and as a JSON document database. This book highlights the newly introduced features in PostgreSQL 10, and shows you how you can build better PostgreSQL applications, and administer your PostgreSQL database more efficiently.