Rajarshi Guha <rguha@xxxxxxxxxxx> 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
