How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL
Summary
The article demonstrates how PostgreSQL can prune partitions even when filtering by non-partition key columns, using check constraints and constraint_exclusion. It covers local vs. global indexes, BRIN multi-minmax for outliers, and technique like gaps-and-islands to derive partition ranges, with practical SQL examples.