Postgres Pro
Downloads
Home   >   mailing lists

Re: Does pg_reset_stats() influence autovacuum? - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Does pg_reset_stats() influence autovacuum?
Date
Msg-id 20120824024748.GA5965@momjian.us
Whole thread Raw
In response to Does pg_reset_stats() influence autovacuum?  (Kouber Saparev <postgres@saparev.com>)
Responses Re: Does pg_reset_stats() influence autovacuum?  (Kouber Saparev <postgres@saparev.com>)
List pgsql-admin
Tree view 
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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

pgsql-admin by date:

Previous
From: Kouber Saparev
Date:
Subject: Does pg_reset_stats() influence autovacuum?
Next
From: CS DBA
Date:
Subject: Canot access PostgreSQL via psql -h (Vmware Fusion)