Re: hash partitioning - Mailing list pgsql-general

From Scott Marlowe
Subject Re: hash partitioning
Date
Msg-id dcc563d10809030957l9931a1bjf55acdf43ea8918d@mail.gmail.com
Whole thread Raw
In response to hash partitioning  ("David West" <david.west@cusppoint.com>)
List pgsql-general
On Wed, Sep 3, 2008 at 10:24 AM, David West <david.west@cusppoint.com> 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?

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Oracle and Postgresql
Next
From: Oleg Bartunov
Date:
Subject: Re: Case sensitive full text searching