On Fri, 2008-12-12 at 13:20 -0500, Tom Lane wrote:
> Simon Riggs <si...@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.com
 PostgreSQL Training, Services and Support


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to