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

From Tim Haak
Subject Re: Partitioned tables not using index for min and max 8.2.7?
Date
Msg-id 4A4C7E58.4010709@lucidview.net
Whole thread Raw
In response to Re: Partitioned tables not using index for min and max 8.2.7?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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 <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
>
>

--
Tim Haak
Email:  timh@lucidview.net
Tel:      +27 12 658 9019


Attachment

pgsql-sql by date:

Previous
From: "Tena Sakai"
Date:
Subject: Re: it's not NULL, then what is it?
Next
From: Jasmin Dizdarevic
Date:
Subject: Create custom aggregate function and custom sfunc