autovacuum_vacuum_insert_threshold

A configuration parameter specifying the number of inserted tuples needed to trigger an autovacuum

Demonstration of autovacuum_vacuum_insert_threshold's effect - here with autovacuum_vacuum_insert_threshold set to the default 1000:

postgres=# CREATE TABLE foo (id INT);
CREATE TABLE

postgres=# INSERT INTO foo VALUES (generate_series(1,10));
INSERT 0 10

postgres=# SELECT n_tup_ins, last_autovacuum
             FROM pg_stat_user_tables
            WHERE relname='foo';
 n_tup_ins | last_autovacuum 
-----------+-----------------
        10 | 
(1 row)

If autovacuum_vacuum_insert_threshold is changed to 5 (here via a relopt on the table), it will be vacuumed at the next autovacuum pass:

postgres=# ALTER TABLE foo SET (autovacuum_vacuum_insert_threshold = 5);
ALTER TABLE

postgres=# INSERT INTO foo VALUES (generate_series(1,10));
INSERT 0 10

postgres=# SELECT n_tup_ins, last_autovacuum
  FROM pg_stat_user_tables
 WHERE relname='foo';
 n_tup_ins |        last_autovacuum        
-----------+-------------------------------
        20 | 2021-12-14 12:10:13.156198+01
(1 row)

• PostgreSQL documentation: autovacuum_vacuum_insert_threshold

• PostgreSQL v13 new feature: tuning autovacuum on insert-only tables - April 2020 blog article by Laurenze Albe / CyberTec

GUC configuration item, Vacuuming