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. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
