On 08/24/2012 05:47 AM, Bruce Momjian wrote: > On Thu, Aug 23, 2012 at 10:59:56AM +0300, Kouber Saparev wrote: >> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
