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/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
