On Fri, 2008-12-12 at 13:20 -0500, Tom Lane wrote:
> Simon Riggs <simon@2ndQuadrant.com> writes:
> > Solutions can also include
> > * manual mechanism for setting ndistinct that doesn't keep getting
> > overwritten by subsequent ANALYZEs
>
> Hmm, that might actually be the most practical answer for large,
> reasonably-static tables. Especially if we expose the "negative
> stadistinct" feature to let people specify it as a fraction of table
> size.
Works for me. Especially if you want to think more about ANALYZE before
changing that.
-- Simon Riggs www.2ndQuadrant.comPostgreSQL Training, Services and Support