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.
- Title Page
- Copyright and Credits
- About Packt
- Contributors
- Preface
- PostgreSQL Overview
- What is new in PostgreSQL 11.0?
- Summary
- Questions
- Understanding Transactions and Locking
- Making Use of Indexes
- Handling Advanced SQL
- Introducing grouping sets
- Making use of ordered sets
- Understanding hypothetical aggregates
- Utilizing windowing functions and analytics
- Writing your own aggregates
- Summary
- Log Files and System Statistics
- Optimizing Queries for Good Performance
- Learning what the optimizer does
- Understanding execution plans
- Understanding and fixing joins
- Enabling and disabling optimizer settings
- Partitioning data
- Adjusting parameters for good query performance
- Making use of parallel queries
- Introducing JIT compilation
- Summary
- Writing Stored Procedures
- Managing PostgreSQL Security
- Managing network security
- Digging into row-level security – RLS
- Inspecting permissions
- Reassigning objects and dropping users
- Summary
- Questions
- Handling Backup and Recovery
- Making Sense of Backups and Replication
- Deciding on Useful Extensions
- Understanding how extensions work
- Making use of contrib modules
- Using the adminpack module
- Applying bloom filters
- Deploying btree_gist and btree_gin
- Dblink – considering phasing out
- Fetching files with file_fdw
- Inspecting storage using pageinspect
- Investigating caching with pg_buffercache
- Encrypting data with pgcrypto
- Prewarming caches with pg_prewarm
- Inspecting performance with pg_stat_statements
- Inspecting storage with pgstattuple
- Fuzzy searches with pg_trgm
- Connecting to remote servers using postgres_fdw
- Other useful extensions
- Summary
- Troubleshooting PostgreSQL
- Migrating to PostgreSQL
- Migrating SQL statements to PostgreSQL
- Using lateral joins
- Using grouping sets
- Using the WITH clause – common table expressions
- Using the WITH RECURSIVE clause
- Using the FILTER clause
- Using windowing functions
- Using ordered sets – the WITHIN GROUP clause
- Using the TABLESAMPLE clause
- Using limit/offset
- Using OFFSET
- Using temporal tables
- Matching patterns in time series
- Moving from Oracle to PostgreSQL
- Moving from MySQL or MariaDB to PostgreSQL
- Summary
- Migrating SQL statements to PostgreSQL
- Other Books You May Enjoy
Who this book is for
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.