Re: suggestions on improving a query

Rajarshi Guha <rguha@indiana.edu> 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