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 <[email protected]> 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:  [email protected]
Tel:      +27 12 658 9019

begin:vcard
fn:Timothy Haak
n:Haak;Timothy
email;internet:[email protected]
tel;work:+27 12 658 9019
tel;cell:+27 83 778 7100
x-mozilla-html:TRUE
version:2.1
end:vcard

-- 
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to