Postgres Pro
Downloads
Home   >   mailing lists

Re: Change query join order - Mailing list pgsql-performance

From Tom Lane
Subject Re: Change query join order
Date
Msg-id 9969.1262975223@sss.pgh.pa.us
Whole thread Raw
In response to Change query join order  (Kaloyan Iliev Iliev <kaloyan@digsys.bg>)
Responses Re: Change query join order
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Massive table (500M rows) update nightmare
Next
From: Robert Haas
Date:
Subject: Re: Change query join order