You need to VACUUM ANALYZE your tables after you've finished with the bulk load step. And no, behavior on toy tables is not a guide to what the planner will choose to do with large tables. regards, tom lane
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных