circagraph
Sign inSign up

openchronology/timeline-app on GitHub

The OpenChronology repository on GitHub, mirrored by och-import-github: issues and pull requests as durations (ongoing while open), what happened to them as moments, plus releases, milestones, commits and branches. The Branches view shows the most recently active branches each in a track of its own.

Source: https://github.com/openchronology/timeline-app

3,131 moments · 2026-10-05 CE 20:21:49 UTC – 2026-11-16 CE 12:10:45 UTC · by @athan · @athan

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

Vacuum and analyse the large tables after 1-2% of them…