On Wed, Sep 3, 2008 at 10:24 AM, David West <david.west@xxxxxxxxxxxxx> wrote: > Hi folks, > > > > I'm wondering why the postgres planner is not capable of determining the > correct partition for a simple select for the following partitioning scheme, > in which I'd like to automatically divide rows into four sub-tables, ie, a > simple form of hash partitioning. Have you got constraint_exclusion turned on?