max / min explain

Started by adbabout 25 years ago2 messagesgeneral
Jump to latest
#1adb
adb@Beast.COM

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.

#2Brent R. Matzelle
bmatzelle@yahoo.com
In reply to: adb (#1)
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/