Re: Postgresql 8.1.4 - performance issues for select on view using max - Mailing list pgsql-performance

From Dimitri Fontaine
Subject Re: Postgresql 8.1.4 - performance issues for select on view using max
Date
Msg-id 200610182319.41920.dim@dalibo.com
Whole thread Raw
In response to Re: Postgresql 8.1.4 - performance issues for select on view using max  (Ioana Danes <ioanasoftware@yahoo.ca>)
Responses Re: Postgresql 8.1.4 - performance issues for select on
List pgsql-performance
Le mercredi 18 octobre 2006 23:02, Ioana Danes a écrit :
> I tried the partitioning scenario but I've got into
> the same problem. The max function is not using the
> indexes on the two partitioned tables...
>
> Any other thoughts?

Did you make sure your test included table inheritance?
I'm not sure the planner benefits from constraint_exclusion without selecting
the empty parent table (instead of your own union based view).

--
Dimitri Fontaine
http://www.dalibo.com/

Attachment

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [GENERAL] UDF and cache
Next
From: Jeff Davis
Date:
Subject: Re: Postgresql 8.1.4 - performance issues for select on