Apologize for delayed response. On Mon, Dec 3, 2018 at 12:30 PM rajan <vgmon...@gmail.com> wrote: > > 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? > That's right auto-vacuumed might not have triggered -- I think, that because of autovacuum_vacuum_scale_factor setting and most of the time update does not increase the table size.
Following question might not directly be related to your query but just curious to know: Does your table have indexes and by any chance your experiment updating non-index column? Regards, Amul
