Acceptable level of over-estimation?

From: "Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Acceptable level of over-estimation?
Date: 2007-09-24 19:37:41
Message-ID: fd93l6$a7l$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Is there a rule of thumb about when the planner's row estimates are too
high? In particular, when should I be concerned that planner's estimated
number of rows estimated for a nested loop is off? By a factor of 10? 100?
1000?

Carlo

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Stark 2007-09-24 20:18:25 Re: Acceptable level of over-estimation?
Previous Message Carlo Stonebanks 2007-09-24 18:12:01 Re: REPOST: Nested loops row estimates always too high