Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T4SKk-0000Ao-Du for pgsql-admin@postgresql.org; Thu, 23 Aug 2012 08:00:06 +0000 Received: from mx-sf.securax.net ([82.129.27.17]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T4SKe-0002O5-O5 for pgsql-admin@postgresql.org; Thu, 23 Aug 2012 08:00:05 +0000 Received: (qmail 10800 invoked by uid 89); 23 Aug 2012 07:59:57 -0000 Received: by simscan 1.4.0 ppid: 10793, pid: 10796, t: 0.0736s scanners: clamav: 0.97/m: Received: from unknown (HELO ?10.2.2.200?) (kouber@securax.org@89.190.196.121) by mail.support.bg with ESMTPA; 23 Aug 2012 07:59:57 -0000 Message-ID: <5035E2FC.2050805@saparev.com> Date: Thu, 23 Aug 2012 10:59:56 +0300 From: Kouber Saparev User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:14.0) Gecko/20120714 Thunderbird/14.0 MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: Does pg_reset_stats() influence autovacuum? Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201208/101 X-Sequence-Number: 39922 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