Skip site navigation (1)
Skip section navigation (2)
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?
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 24 Sep 2007 15:37:41 -0400
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
- Follow-Ups:
- Re: Acceptable level of over-estimation?
- From: Gregory Stark
- Re: Acceptable level of over-estimation?
- Prev by Date: Re: REPOST: Nested loops row estimates always too high
- Next by Date: Re: Acceptable level of over-estimation?
- Previous by thread: TEXT or LONGTEXT?
- Next by thread: Re: Acceptable level of over-estimation?
- Indexes: