Re: Best way to get the latest revision from a table - Mailing list pgsql-performance

Shaun Thomas <sthomas@peak6.com> wrote:

> This actually looks like a perfect candidate for DISTINCT ON.
>
> SELECT DISTINCT ON (a, b) a, b, revision
>    FROM test
>   ORDER BY a, b DESC;

I wouldn't say perfect.  It runs about eight times slower than what
I suggested and returns a fairly random value for revision instead
of the max(revision).

-Kevin