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