Re: [GENERAL] a question about row estimation in postgres

2011-03-20 Thread Nathan Boley
> Following the formula outlined > in http://www.postgresql.org/docs/8.3/static/row-estimation-examples.html > Both gradrate 10 and gradrate 11 would fall in the first bucket. > Shouldn't the row estimation be: > (11 - 8) / (33 - 8) / 10 * 1302 = 15.624 > and > (10 - 8) / (33 - 8) / 10 * 1302 = 10.

Re: [GENERAL] a question about row estimation in postgres

2011-03-20 Thread Tomas Vondra
Dne 20.3.2011 08:20, Reynold Xin napsal(a): > Following the formula outlined > in http://www.postgresql.org/docs/8.3/static/row-estimation-examples.html > > Both gradrate 10 and gradrate 11 would fall in the first bucket. > > Shouldn't the row estimation be: > > (11 - 8) / (33 - 8) / 10 * 1302 =