↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Feature: Partition pruning during query execution

Queries on partitioned tables can eliminate partitions during query execution time, instead of only at query planning time. This allows PostgreSQL to use information that becomes available during query execution to further prune the number of partitions it needs to use, leading to improved query performance.