Compute PostgreSQL duration summaries set-based over a start index
- github
- github/openchronology/timeline-app
- commit
- main
- github/athanclark
oc_duration_overview no longer walks the interval tree, which long durations forced to visit nearly every node at whole-timeline zoom. Each group's anchor is the first collapsed start at or after the previous anchor plus the threshold, found by an index range scan, and the group is aggregated over the starts before the next anchor. Arbitrarily large mpq values stay out of B-tree keys: a stored generated float8 approximation of each start is indexed instead. Rounding never reverses the order of two starts, so approximate ranges hold every exact match and exact mpq comparisons recheck each row. The equivalence test now also covers starts beyond float8's range, whose approximations saturate and tie. Co-Authored-By: Claude Opus 5.5 Claude-Session: https://claude.ai/code/session_01Ti36soiZpKdSxKfvQLEcfY https://github.com/openchronology/timeline-app/commit/0c52d59f4717061ba29e5e537fac6f8b8b4c5a2b
Open Compute PostgreSQL duration summaries set-based over a start index in the timeline