Re: partitioning for speed, but query planner ignores

From: David Rysdam <drysdam(at)ll(dot)mit(dot)edu>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: partitioning for speed, but query planner ignores
Date: 2013-10-02 13:00:33
Message-ID: 87ioxfsu8e.fsf@loud.llan.ll.mit.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2 Oct 2013 08:34:44 -0400, David Rysdam <drysdam(at)ll(dot)mit(dot)edu> wrote:
> However, when I run an explain or an explain analyze, I still seeing it
> checking both partitions. Is this because the query planner doesn't want
> to do a mod? Should I go with simple ranges, even though this adds a
> maintenance task?

I guess I should give some administrivia as well: Server is 9.2.1
running Linux. The configuration is otherwise pretty vanilla with only
minor, and poorly-understood, conf changes.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2013-10-02 13:12:02 Re: partitioning for speed, but query planner ignores
Previous Message Karsten Hilbert 2013-10-02 12:58:06 Re: Timestamp with and without timezone conversion confusion.