Re: slow joining very large table to smaller ones - Mailing list pgsql-performance

From Tom Lane
Subject Re: slow joining very large table to smaller ones
Date
Msg-id 5708.1121383802@sss.pgh.pa.us
Whole thread Raw
In response to Re: slow joining very large table to smaller ones  (John A Meinel <john@arbash-meinel.com>)
Responses Re: slow joining very large table to smaller ones  (John A Meinel <john@arbash-meinel.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: John A Meinel
Date:
Subject: Re: slow joining very large table to smaller ones
Next
From: John A Meinel
Date:
Subject: Re: slow joining very large table to smaller ones