Postgres Pro
Downloads
Home   >   mailing lists

Acceptable level of over-estimation? - Mailing list pgsql-performance

From Carlo Stonebanks
Subject Acceptable level of over-estimation?
Date
Msg-id fd93l6$a7l$1@news.hub.org
Whole thread Raw
Responses Re: Acceptable level of over-estimation?
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Carlo Stonebanks"
Date:
Subject: Re: REPOST: Nested loops row estimates always too high
Next
From: Gregory Stark
Date:
Subject: Re: Acceptable level of over-estimation?