Re: [SQL] Partitioned tables not using index for min and max 8.2.7?

2009-07-02 Thread Tim Haak
Cool thanks then not something I'm doing wrong :). Is this going to be changed or is changed in a latter version of postgres. (Do I need to do and upgrade or write a work around :) ) Tom Lane wrote: Tim Haak writes: I am running the following query again a partitioned table in 8.2.

[SQL] Partitioned tables not using index for min and max 8.2.7?

2009-07-01 Thread Tim Haak
=0.00..0.06 rows=1 width=8)" " -> Index Scan using idx_table_log_date_only on table (cost=0.00..68272.93 rows=1215710 width=8)" "Filter: (log_date IS NOT NULL)" Am I doing something wrong or is this expected. I tried the old method of S