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

From Kouber Saparev
Subject Re: Does pg_reset_stats() influence autovacuum?
Date
Msg-id k1hvu5$c8g$1@ger.gmane.org
Whole thread Raw
In response to Re: Does pg_reset_stats() influence autovacuum?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
On 08/24/2012 05:47 AM, Bruce Momjian wrote:
> 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.
>

So, I guess the only safe moment to reset stats is right after manual
vacuum analyze.

Thanks.

--
Kouber Saparev

pgsql-admin by date:

Previous
From: Rural Hunter
Date:
Subject: Fwd: Delivery Status Notification (Failure)
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: symbol lookup error: /usr/pgsql-9.1/bin/pg_ctl: undefined symbol: PQping