Re: slow joining very large table to smaller ones

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John A Meinel <john(at)arbash-meinel(dot)com>
Cc: Dan Harris <fbsd(at)drivefaster(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: slow joining very large table to smaller ones
Date: 2005-07-14 23:30:02
Message-ID: 5708.1121383802@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

John A Meinel <john(at)arbash-meinel(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message John A Meinel 2005-07-14 23:39:58 Re: slow joining very large table to smaller ones
Previous Message John A Meinel 2005-07-14 23:12:55 Re: slow joining very large table to smaller ones