>>> "Robert Haas" <robertmh...@gmail.com> wrote: >> 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". The table has 32.4 million rows. autovacuum_analyze_scale_factor is 0.1. autovacuum_vacuum_scale_factor is 0.2. We run a nightly VACUUM ANALYZE. Deletes are rare. Normal operations don't update more than a few thousand rows per day. I know that normal operations never cause an autovacuum of this table. Perhaps if there was a way to share this information with PostgreSQL.... -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
