The sys_audit branches aggregate older change sets before the cursor rank/id and text search are applied, so each page rebuilds field payloads for every older row. At current volumes this is acceptable; if the trail grows or all-time exports become common, pre-aggregate change sets (a materialised key table or a bounded keys-first CTE) so paging is O(page), not O(trail).
Imported from beads archie-core-wwhoz.13 · GitHub #1911 · type task · priority P3 · created 2026-10-25
The sys_audit branches aggregate older change sets before the cursor rank/id and text search are applied, so each page rebuilds field payloads for every older row. At current volumes this is acceptable; if the trail grows or all-time exports become common, pre-aggregate change sets (a materialised key table or a bounded keys-first CTE) so paging is O(page), not O(trail).
---
_Imported from beads `archie-core-wwhoz.13` · GitHub #1911 · type task · priority P3 · created 2026-10-25_
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
The sys_audit branches aggregate older change sets before the cursor rank/id and text search are applied, so each page rebuilds field payloads for every older row. At current volumes this is acceptable; if the trail grows or all-time exports become common, pre-aggregate change sets (a materialised key table or a bounded keys-first CTE) so paging is O(page), not O(trail).
Imported from beads
archie-core-wwhoz.13· GitHub #1911 · type task · priority P3 · created 2026-10-25