Postgres Pro
Downloads
Home   >   mailing lists

Re: Partitioned tables not using index for min and max 8.2.7? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Partitioned tables not using index for min and max 8.2.7?
Date
Msg-id 13724.1246470286@sss.pgh.pa.us
Whole thread Raw
In response to Partitioned tables not using index for min and max 8.2.7?  (Tim Haak <timh@lucidview.net>)
Responses Re: Partitioned tables not using index for min and max 8.2.7?
List pgsql-sql
Tree view 
Tim Haak <timh@lucidview.net> writes:
> I am running the following query again a partitioned table in 8.2.7. It 
> does index scans which is unexpected as there are indexes for the 
> log_date column.

The index min/max optimization only works on single tables at the
moment.  Sorry.
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: it's not NULL, then what is it?
Next
From: "Tena Sakai"
Date:
Subject: Re: it's not NULL, then what is it?