"Jim C. Nasby" <jnasby@xxxxxxxxxxxxx> writes: > And even then you better have a pretty high correlation on the first > column, otherwise you'll still get a seqscan. Not with the LIMIT. (If he were fetching the whole table, very possibly the sort would be the right plan anyway.) regards, tom lane