max / min explain
Started by adbabout 25 years ago2 messagesgeneral
I've noticed that select max(the_primary_key) from some_table
does a table scan. Is there any plan to implement max/min calculations
using index lookups if the appropriate index exists?
Thanks,
Alex.
Re: max / min explain
Yes there is. You can find it in the TODO list under
Performance -> Indexes
(http://www.postgresql.org/docs/todo.html). It isn't
slated for the 7.1 release however.
Brent
--- adb <adb@Beast.COM> wrote:
I've noticed that select max(the_primary_key) from
some_table
does a table scan. Is there any plan to implement
max/min
calculations
using index lookups if the appropriate index exists?Thanks,
Alex.
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
Import Notes
Resolved by subject fallback