Every advanced user of SQL should be familiar with GROUP BY and HAVING clauses. But are they also aware of CUBE, ROLLUP, and GROUPING SETS? If not, this chapter is a must-read.
- 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
Introducing grouping sets
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.