enable_partition_pruning

A configuration parameter determining whether partition pruning should be implemented by the planner

enable_partition_pruning is a configuration parameter determining whether partition pruning should be implemented by the planner.

enable_partition_pruning was added in PostgreSQL 11.

Default value

The default value for enable_partition_pruning is: on.

Change history

Categories

GUC configuration item, Partitioning, Planner

See also

enable_partitionwise_join, enable_partitionwise_aggregate, constraint_exclusion