Home > mailing lists

Re: Joint index including MAX() ? - Mailing list pgsql-performance

From	Grzegorz Jaśkiewicz
Subject	Re: Joint index including MAX() ?
Date	January 9, 2010 11:51:54
Msg-id	2f4958ff1001090451j69934f2awce0a4c1fc7a27364@mail.gmail.com Whole thread Raw
In response to	Joint index including MAX() ? (Richard Neill <rn214@cam.ac.uk>)
List	pgsql-performance

you can also try :

select val FROM table ORDER BY val DESC LIMIT 1;

which usually is much quicker.

From: Kenneth Marshall
Date: 09 January 2010, 11:46:44
Subject: Re: PG optimization question

From: Lefteris
Date: 09 January 2010, 11:52:44
Subject: Re: Joint index including MAX() ?