Have you run analyze on all the three tables since creating the database?
yes. even a forced ANALYZE FULL after the table loads: the tables were TRUNCATE'd, refilled and ANALYZE FULL'ed some minutes before the tests. there where no UPDATEs after the INSERTs...
- thomas
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
