Обсуждение: Version 11 partitioning: Constraint exclusion vs Partition Pruning
Good afternoon,
--
I am contemplating implementing partitioning in Postgres v 11. I am reading the documentation and came across this statement in the Constraint Exclusion section:
Constraint exclusion only works when the query's
WHERE clause contains constants (or externally supplied parameters). Is this true also in Partition pruning? I don't see a similar statement in that section.
If we can place variables in the where clause and have partitioning still work, that would be an awesome enhancement. I see that Declarative partitioning was implemented in version 10 and a whole raft of partitioning enhancements in version 11. (We are currently at 9.4 and want to upgrade as well).
Mark Steben
Database Administrator
@utoRevenue | Autobase
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567
Database Administrator
@utoRevenue | Autobase
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567
www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com
Mark Steben wrote: > I am contemplating implementing partitioning in Postgres v 11. I am > reading the documentation and came across this statement in the > Constraint Exclusion section: > Constraint exclusion only works when the query's WHERE clause > contains constants (or externally supplied parameters). > Is this true also in Partition pruning? I don't see a similar > statement in that section. In v11, partition pruning will also work at query execution time, that is, you don't have to use a constant. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com