Hello Amul, I have a doubt. Please find below the details,
1. autovacuum_vacuum_threshold and autovacuum_analyse_threshold are set at 300 2. autovacuum_vacuum_scale_factor and autovacuum_analyse_scale_face are set at 300 3. there is table which has only 6 records 4. and the number of updates happened in the table is 944 5. now when I fetch data from pg_stat_user_table, i find that only last_autoanalyse column is updated with datetime and last_autovacuum column is not having a value does this mean only autoanalyse was executed for this table? But when I have both vacuum_threshold and analyse_threshold set at 300, how can only analyse run and vacuum does not? This may be a stupid question. But any answer can help me understand. ----- -- Thanks, Rajan. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
