On Fri, 2008-12-12 at 13:20 -0500, Tom Lane wrote: > Simon Riggs <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
