Re: benchmarking the query planner

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