Re: sequential scan on child partition tables - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: sequential scan on child partition tables
Date
Msg-id dcc563d10910172208g21b751b3p626c5a55b75f960a@mail.gmail.com
Whole thread Raw
In response to Re: sequential scan on child partition tables  (Anj Adu <fotographs@gmail.com>)
List pgsql-performance
On Thu, Oct 15, 2009 at 2:51 PM, Anj Adu <fotographs@gmail.com> wrote:
> This appears to be a bug in the optimizer with resepct to planning
> queries involving child partitions. It is clear that "any" index is
> being ignored even if the selectivity is high. I had to re-write the
> same query by explicitly "union-all" ' ing  the queries for individual
> partitions.

So, did adjusting cost parameters help at all?

pgsql-performance by date:

Previous
From: Melton Low
Date:
Subject: Re: table full scan or index full scan?
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: Issues with \copy from file