Kaloyan Iliev Iliev <kaloyan@digsys.bg> 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