Skip site navigation (1) Skip section navigation (2)

Re: Does pg_reset_stats() influence autovacuum?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Kouber Saparev <postgres(at)saparev(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Does pg_reset_stats() influence autovacuum?
Date: 2012-08-24 02:47:48
Message-ID: 20120824024748.GA5965@momjian.us (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


In response to

Responses

pgsql-admin by date

Next:From: CS DBADate: 2012-08-24 04:15:49
Subject: Canot access PostgreSQL via psql -h (Vmware Fusion)
Previous:From: Kouber SaparevDate: 2012-08-23 07:59:56
Subject: Does pg_reset_stats() influence autovacuum?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group