Rafael Martinez wrote:
> Does the use of pg_stat_reset() affects the statistics autovacuum uses
> to find out what to do and when this should be done?
Yes. You should do a manual ANALYZE after resetting stats to keep
autovacuum in sync with reality. (In principle ANALYZE is only
concerned with
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello
We are playing around with different statistics provided by postgresql
to get a better overview of our systems.
Until postgresql 8.2, and the presence of
'stats_reset_on_server_start=on' + pg_postmaster_start_time(), we could
calculate very eas
