Audit feed: push cursor and search into the sys_audit grouping #498

Open
opened 2026-10-27 13:36:33 +00:00 by sam · 0 comments
Owner

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_
sam added the lowtask labels 2026-10-27 13:36:34 +00:00
sam self-assigned this 2026-10-27 13:36:34 +00:00
sam added the deferred label 2026-11-15 17:26:24 +00:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: sam/archie#498