0
preview
Wrote this after seeing partition pruning silently fail with a parameterized query - the planner can’t prune on a value it doesn’t have yet at plan time. Covers the three common ways people accidentally defeat pruning and how to check EXPLAIN to tell whether it actually fired.
Wrote this after seeing partition pruning silently fail with a parameterized query - the planner can’t prune on a value it doesn’t have yet at plan time. Covers the three common ways people accidentally defeat pruning and how to check EXPLAIN to tell whether it actually fired.