Re: Spped of max

On Tue, May 14, 2002 at 01:27:30PM -0400, Edmund Dengler wrote:
> Greetings all!
>
> Quick question: how long should finding the maximum value in a column
> take?

This is a known issue: max() requires a sequential scan of the
table.

Since PostgreSQL allows user-defined aggregates, this is somewhat
difficult to optimize. No one has yet bothered to create special
cases for max(), min() and perhaps count(), although it could
probably be done.

I'd suggest simply using the workaround you noticed (ORDER BY,
LIMIT 1).

> Now, this type of thing gets me real worried about how good the
> optimizer really is.

The problem doesn't involve the optimizer, AFAICT.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC