Re: hash partitioning

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "David West" <david(dot)west(at)cusppoint(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: hash partitioning
Date: 2008-09-03 16:57:36
Message-ID: dcc563d10809030957l9931a1bjf55acdf43ea8918d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 3, 2008 at 10:24 AM, David West <david(dot)west(at)cusppoint(dot)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?

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-09-03 16:59:42 Re: Backslash Escape Sequences
Previous Message Scott Marlowe 2008-09-03 16:53:40 Re: Oracle and Postgresql