This book is ideal for PostgreSQL developers and administrators, as well as database admins who have some familiarity with PostgreSQL and database management. Prior exposure to PostgreSQL and familiarity with the basics of database administration is expected.
- Title Page
- Copyright and Credits
- About Packt
- Contributors
- Preface
- Section 1: Basic Overview
- PostgreSQL 12 Overview
- Understanding Transactions and Locking
- Section 2: Advanced Concepts
- 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
- Gathering runtime statistics
- Working with PostgreSQL system views
- Creating log files
- Summary
- Questions
- Gathering runtime 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 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 searching 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 the OFFSET clause
- Using temporal tables
- Matching patterns in time series
- Moving from Oracle to PostgreSQL
- Summary
- Migrating SQL statements to PostgreSQL
- Assessment
- 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.