Skip to content

Glossary: PostgreSQL Beyond the Basics

Partition pruning

Also written: pruning, Subplans Removed

Skipping the partitions a query can't need, which requires the partition key in the WHERE clause. It can happen at plan time or at run time.

Where the book teaches it

Related terms

Partition, partition keyAppend