I then did ’select * from AMARKETS order by STARTTS’
Is amarkets in more then one schema?
Yeah, it's hard to think of any explanation other than "the query used a corrupt index on startts to produce the ordering". But your \d doesn't show any index on startts. So maybe there's more than one amarkets table?
Yes - in other schemas - described in reply to Adrain
But the schema_path does not point to them
And those two other tables are empty
Another possibly-useful bit of evidence is to see what EXPLAIN shows as the query plan for this query.
bnl=> explain select * from amarkets order by startts;