PostgreSQL Autovacuum tip - Githubissues

PhVHoang / TIL

10 stars 0 forks source link

PostgreSQL Autovacuum tip #386

Open PhVHoang opened 1 year ago

PhVHoang commented 1 year ago

postgres=# ALTER TABLE pgbench_accounts SET (autovacuum_vacuum_threshold = 1000);
ALTER TABLE
postgres=# ALTER TABLE pgbench_accounts SET (autovacuum_vacuum_scale_factor = 0.0);
ALTER TABLE

References

https://www.interdb.jp/blog/pgsql/autovacuum1/