Vacuum and analyse the large tables after 1-2% of them change
- github
- github/openchronology/timeline-app
- commit
- main
- github/athanclark
Autovacuum's defaults wait for 20% of a table to change (10% for statistics), far too late at hundreds of millions of rows. The migration sets the index, retired-version and history tables to vacuum after 2% changed or added rows and analyse after 1%, only where a table has no value of its own, so an administrator's tuning survives upgrades and unchanged tables take no lock. Closes #135. Co-Authored-By: Claude Opus 5.5 Claude-Session: https://claude.ai/code/session_011fFY8eruEi1xAkkMBni13B https://github.com/openchronology/timeline-app/commit/0071584f28f41af6608e539f6f2760b19a35c19a
Related
Open Vacuum and analyse the large tables after 1-2% of them change in the timeline