Kaloyan Iliev Iliev <[email protected]> writes: > My question is why the planner didn't do the index scan first on ms_data > to reduce the rows to ~ 11000 and the use the PK index on > ms_commands_history.
11000 index probes aren't exactly free. If they take more than about
1msec apiece, the planner picked the right plan.
regards, tom lane
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
