Primoz <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
