| From: | Tim Haak <timh(at)lucidview(dot)net> |
|---|---|
| To: | |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Partitioned tables not using index for min and max 8.2.7? |
| Date: | 2009-07-02 09:31:04 |
| Message-ID: | 4A4C7E58.4010709@lucidview.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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
>
>
--
Tim Haak
Email: timh(at)lucidview(dot)net
Tel: +27 12 658 9019
| Attachment | Content-Type | Size |
|---|---|---|
| timh.vcf | text/x-vcard | 170 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jasmin Dizdarevic | 2009-07-02 14:48:50 | Create custom aggregate function and custom sfunc |
| Previous Message | Tena Sakai | 2009-07-01 17:47:36 | Re: it's not NULL, then what is it? |