Re: [ADMIN] Does pg_reset_stats() influence autovacuum?

2012-08-28 Thread Kouber Saparev
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

[ADMIN] Does pg_reset_stats() influence autovacuum?

2012-08-23 Thread Kouber Saparev
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

Re: [ADMIN] Does pg_reset_stats() influence autovacuum?

2012-08-23 Thread Bruce Momjian
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