Rajarshi Guha <[EMAIL PROTECTED]> writes:
> However the clause: 
>     dock.target = '1YC1' and  
>     dock.dockid = dockscore_plp.id  
> reduces the number of rows from 4.6M to 96K.

The planner seems to be estimating about ten times that many.  Perhaps
increasing the statistics target for dock.target would help?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to