Re: slow joining very large table to smaller ones

John A Meinel <john@arbash-meinel.com> 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