Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T4jw7-00016j-DC for pgsql-admin@postgresql.org; Fri, 24 Aug 2012 02:47:51 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T4jw5-00015x-Oa for pgsql-admin@postgresql.org; Fri, 24 Aug 2012 02:47:50 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1T4jw4-0001AC-9G; Thu, 23 Aug 2012 22:47:48 -0400 Date: Thu, 23 Aug 2012 22:47:48 -0400 From: Bruce Momjian To: Kouber Saparev Cc: "pgsql-admin@postgresql.org" Subject: Re: Does pg_reset_stats() influence autovacuum? Message-ID: <20120824024748.GA5965@momjian.us> References: <5035E2FC.2050805@saparev.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5035E2FC.2050805@saparev.com> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -2.1 (--) X-Archive-Number: 201208/102 X-Sequence-Number: 39923 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 http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +