John A Meinel <[EMAIL PROTECTED]> writes: > What I don't understand is that the planner is actually estimating that > joining against the new table is going to *increase* the number of > returned rows.
It evidently thinks that incidentid in the k_r table is pretty nonunique. We really need to look at the statistics data to see what's going on. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings