On Tue, Aug 18, 2009 at 06:30:15AM -0700, Anj Adu wrote:
> We are testing 8.4 and noticed that the performance of
>
> select max(indexed_col) from parent_Table
>
> is the same (slow) as postgres 8.1.x ( our current version). The
> child tables are huge and the indexed_col is not the basis for
> partitioning.
>
> I remember that this was an issue from an earlier thread where the
> optimizer was not able to use the child partitions only to get the max
> value. Is this true for 8.4 ?
>
This is still a problem as of 8.4.
Regards,
Ken