Re: [GENERAL] Row number estimation...

2014-10-18 Thread marin
On Sat, 18 Oct 2014 11:34:18 -0400, Tom Lane wrote: > If the comparison value is outside the range recorded in the histogram, > and there's a suitable index available, the planner uses the index to > find out the actual column min or max rather than believing the histogram > completely. See get

Re: [GENERAL] Row number estimation...

2014-10-18 Thread Tom Lane
writes: > Yesterday I was trying to calculate by hand the row number estimates using > the examples from > http://www.postgresql.org/docs/9.3/static/row-estimation-examples.html > It is usually correct, except when you try to get an estimate near the > first (or last) histogram bound. Let me demon