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
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