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 <t...@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:  t...@lucidview.net
Tel:      +27 12 658 9019

begin:vcard
fn:Timothy Haak
n:Haak;Timothy
email;internet:t...@lucidview.net
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 (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to