> Without a WHERE you get the whole table. > > A Index-Scan is, in this case, expensive.
I know that, and I would agree if I wouldn't have asked for _ordered_ result, and wouldn't have turned enable_seqscan=off. In these conditions I would have expected an index scan, even if it is more expensive than the sequential scan + sort. Actually I wanted to see how expensive it thinks it is, but I can't get to that plan at all. Thanks, Csaba. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
