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
In response to
pgsql-hackers by date
|Next:||From: Patrick Welche||Date: 2000-03-07 17:22:15|
|Subject: Re: [HACKERS] alter_table.sql|
|Previous:||From: Lamar Owen||Date: 2000-03-07 16:57:50|
|Subject: Re: [HACKERS] library policy question|