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.
0
Why your partitioned table isn't actually getting pruned
https://slowquerylogpg.mataroa.blog/blog/why-your-partitioned-table-isnt-actually-getting-pruned/
0 comments
log in to comment.