Tom Lane wrote:
Maxim Boguk <[EMAIL PROTECTED]> writes:
[ ndistinct estimates way off ]
Estimating the number of distinct values in a distribution with a long
tail is just a really hard problem :-(
If I have a table where I know it has this property, is there
any way I can tell autovacuum's ANALYZE to go ahead and scan
the whole table? ISTM a vacuum_cost_delay throttled full
table scan might be less harmful then a bad ndistinct guess.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
