Re: [HACKERS] Estimating geometric distributions

2008-03-11 Thread Stephen Denne
I wrote: > > I have a field whose distribution of frequencies of values is > > roughly geometric, rather than flat. > My problem is frequent > > over-estimation of rows when restricting by this field with > > values not known at plan time. > Is there any facility already in PostgreSQL to hel

[HACKERS] Estimating geometric distributions

2008-03-09 Thread Stephen Denne
I wrote: > I have a field whose distribution of frequencies of values is > roughly geometric, rather than flat. > Total rows = 36 million > relpages=504864 > Distinct field values in use = 169 > 10 values account for 50% of the rows. > 41 values account for 90% of the rows. > > After setting stat