Does pg_reset_stats() influence autovacuum?

[Kouber Saparev]

Hello,

Does resetting of stats through pg_reset_stats() influence the way
autovacuum determines whether autovacuum_vacuum_scale_factor and
autovacuum_analyze_scale_factor settings are reached?

In other words, are the n_live_tup and n_dead_tup values kept somewhere
internally, apart pg_stat_all_tables?

--
Kouber Saparev

[Bruce Momjian]

Post by Kouber Saparev
Hello,
Does resetting of stats through pg_reset_stats() influence the way
autovacuum determines whether autovacuum_vacuum_scale_factor and
autovacuum_analyze_scale_factor settings are reached?
In other words, are the n_live_tup and n_dead_tup values kept somewhere
internally, apart pg_stat_all_tables?

No. pg_reset_stats() will affect autovacuum, usually in a bad way.
--
Bruce Momjian <***@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

[Kouber Saparev]

Post by Bruce Momjian

Post by Kouber Saparev
Hello,
Does resetting of stats through pg_reset_stats() influence the way
autovacuum determines whether autovacuum_vacuum_scale_factor and
autovacuum_analyze_scale_factor settings are reached?
In other words, are the n_live_tup and n_dead_tup values kept somewhere
internally, apart pg_stat_all_tables?

No. pg_reset_stats() will affect autovacuum, usually in a bad way.

So, I guess the only safe moment to reset stats is right after manual
vacuum analyze.

Thanks.

--
Kouber Saparev