Csaba Nagy wrote:
select * from table order by col_1; Isn't it supposed to choose the index scan at least when enable_seqscan=off ? Even if it is indeed not faster to do the index scan than seqscan+sort.
I think because you've asked for every row, it's going to have to scan the whole table anyway, to determine MVCC "liveness" of the rows (sorry, dunno what the correct word is).
- John Burger MITRE
