Does pg_reset_stats() influence autovacuum? - Mailing list pgsql-admin

From Kouber Saparev
Subject Does pg_reset_stats() influence autovacuum?
Date
Msg-id 5035E2FC.2050805@saparev.com
Whole thread Raw
Responses Re: Does pg_reset_stats() influence autovacuum?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: creating trigger in 8.3 -- very slow
Next
From: Bruce Momjian
Date:
Subject: Re: Does pg_reset_stats() influence autovacuum?