Mladen Gogala escreveu: > Optimizer chooses to scan each partitioned table sequentially, instead of > using the available index: > This is not a bug. How would the optimizer know that the maximum value is in that specific partition? There is neither a global index for a partitioned table nor an optimizer artifact to know aggregate information before scanning all of the partitions. Maybe when we have a better support for table partitioning such optimizer artifact would be implemented but don't hold your breath.
-- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs