Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group