Postgresql database operations becomes slower if table gets larger. In order to improve the performance, we can configure to auto-vacuum the table for every x inserts/updates/deletes.
Using below settings, a table would be auto vacuumed and analysed every 5,000 inserts, updates, or deletes.
ALTER TABLE mytable SET (autovacuum_vacuum_scale_factor = 0.0);
ALTER TABLE mytable SET (autovacuum_analyze_scale_factor = 0.0);
ALTER TABLE mytable SET (autovacuum_vacuum_threshold = 10000);