Accelerate Postgres Record List Reads
completetasks10/10accelerate-postgres-record-list-reads
openspec/changes/accelerate-postgres-record-list-reads/View on GitHub →
Artifacts
Official change artifacts tracked under openspec/.
Proposal
Large Postgres-backed record streams were not "blazing fast" on the public read surface. Live evidence on pdpp.vivid.fish showed a Slack messages page spending about 1.3s sorting recordjson->>cursorfield, and count:"exact" spending about 1.1s scanning the full records table.
Design
The reference Postgres store has grown large enough that JSON-derived ordering and whole-table exact counts are owner-visible latency. Live EXPLAIN ANALYZE showed:
Tasks (10/10)
Spec Deltas (1)
Affected capabilities
Capability specs this change proposes to modify.