On Wed, 2007-11-07 at 17:18 +0100, Jacques Caron wrote:
> It is well known that in some instances the Postgresql will make
> estimates of the number of distinct values in a table that can be
> quite far off reality. This then has a tendency to make the planner
> lean towards unsavory plans (rea
Hi,
It is well known that in some instances the Postgresql will make
estimates of the number of distinct values in a table that can be
quite far off reality. This then has a tendency to make the planner
lean towards unsavory plans (read: seqscans) because it estimates the
number of lines retu
