Tobias Brox <[EMAIL PROTECTED]> writes: > NBET=> explain select * from account_transaction where users_id=123456 order > by created desc, id desc limit 10;
> We have indices on the users_id field and the (users_id, created)-tuple.
Neither of those indexes can provide the sort order the query is asking
for.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
