Version 11 partitioning: Constraint exclusion vs Partition Pruning

Mark Steben <[email protected]>
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <CADyzmyyd7GNThHRWdEudtxDr8OXriQu8XUdEon0WtqAQ-tq89w@mail.gmail.com>
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 <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
  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 <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.