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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tim Haak <timh(at)lucidview(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Partitioned tables not using index for min and max 8.2.7?
Date: 2009-07-01 17:44:46
Message-ID: 13724.1246470286@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tim Haak <timh(at)lucidview(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tena Sakai 2009-07-01 17:47:36 Re: it's not NULL, then what is it?
Previous Message Tom Lane 2009-07-01 17:42:27 Re: it's not NULL, then what is it?