Re: benchmarking the query planner

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/