Now that we've dug into some important optimizations that are implemented in PostgreSQL, let's proceed to take a closer look at execution plans. You have already seen some execution plans in this book. However, in order to make full use of plans, it is important to develop a systematic approach when it comes to reading this information.
- 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
Understanding execution plans
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.