Re: Indexes

Primoz <primoz@slo-tech.com> writes:

is there any way to speedup queryes like

select ... from [table a] where [int field b] = [number] order by [datetime
field c] desc limit [number];

For reasonably-small values of the LIMIT, what you want is
(a) a two-column index on (b,c)
(b) change the ORDER BY to
ORDER BY b DESC, c DESC

See the pgsql-performance archives for more discussion.

regards, tom lane