Re: Inaccurate row count estimation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vyacheslav Kalinin" <vka(at)mgcp(dot)com>
Cc: PGSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Inaccurate row count estimation
Date: 2008-07-10 03:26:14
Message-ID: 21515.1215660374@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Vyacheslav Kalinin" <vka(at)mgcp(dot)com> writes:
> How come that outermost join expects 1515 rows given the row estimations of
> the inner and outer nested loop's parts?

I couldn't reproduce such a problem. What PG version are you running?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-07-10 03:37:51 Re: SELECT Query returns empty
Previous Message Bright D.L. 2008-07-10 03:12:50 Re: SELECT Query returns empty