Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> writes:
> OK - got it! It is because vacuum analyze <tablename> doesn't work for me,
> therefore the select doesn't use indices, so uses a sequential rather than
> index scan => my rows are returned out of order.
Ah so. I think you mentioned before that you were seeing trouble with
VACUUM ANALYZE --- we need to find out what the problem is. What
platform are you on, and what are you seeing exactly?
regards, tom lane