Yang Zhang escribió:
> I have the exact same table of data in both MySQL and Postgresql. In Postgresql:
I just noticed two things:
[snip lots of stuff]
1.
> ) ENGINE=MyISAM AUTO_INCREMENT=50410166 DEFAULT CHARSET=latin1
You're doing a comparison to MyISAM.
2.
> select * from metarelcloud_transactionlog order by transactionid;
You're reading the whole table.
This is unlikely to fly very far. I suggest you try some query that's
actually going to be used in the real world.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.