Robert Haas escreveu:
>> Which raises the issue, if we could get better statistics by passing
>> the whole table, why not do that when VACUUM ANALYZE is run?
>
> I think the reason is "because the next autovacuum would undo it".
>
Ok, but even if autovacuum will undo it, almost-static-dataset would benefit
from this feature because (i) autovacuum won't often trigger this table or
(ii) you disabled the autovacuum on that table.
> Perhaps a table-level option to scan the whole table instead of
> estimating would be appropriate?
>
ANALYZE FULL foo ?
-- Euler Taveira de Oliveira http://www.timbira.com/
