On Thu, Oct 15, 2009 at 2:51 PM, Anj Adu <fotographs@xxxxxxxxx> 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? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance