Robert Haas escribió: > > 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".
Is there any way to "merge" the statistics? i.e. if a full table scan is done to compute precise statistics, and later a regular analyze scan is done, then perhaps instead of clobbering the previous stats, you merge them with the new ones, thus not completely losing those previous ones. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
