Re: Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1 - Mailing list pgsql-general

> Already done in 8.1.  Here's an excerpt from the Release Notes:
>
> Automatically use indexes for MIN() and MAX() (Tom)
>
>     In previous releases, the only way to use an index for MIN()
>     or MAX() was to rewrite the query as SELECT col FROM tab ORDER
>     BY col LIMIT 1.  Index usage now happens automatically.
>

Which query form will generally be faster in 8.1 (or will they be
exactly the same)?

BJ