Postgres Pro
Downloads
Home   >   mailing lists

Re: partitioning for speed, but query planner ignores - Mailing list pgsql-general

From David Rysdam
Subject Re: partitioning for speed, but query planner ignores
Date
Msg-id 87ioxfsu8e.fsf@loud.llan.ll.mit.edu
Whole thread Raw
In response to partitioning for speed, but query planner ignores  (David Rysdam <drysdam@ll.mit.edu>)
List pgsql-general
Tree view 
On Wed, 2 Oct 2013 08:34:44 -0400, David Rysdam <drysdam@ll.mit.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.
Attachment

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Timestamp with and without timezone conversion confusion.
Next
From: Bill Moran
Date:
Subject: Re: partitioning for speed, but query planner ignores