defer SourceEvidence reindex pending bloat evidence

c97856c6fda7086b2f151d1ee2a538128625643e · 2026-09-01 17:52:53 -0700 · Steve

Files touched

M ops/sourceevidence-maintenance.sql

Diff

commit c97856c6fda7086b2f151d1ee2a538128625643e
Author: Steve <steve@designerwallcoverings.com>
Date:   Tue Sep 1 17:52:53 2026 -0700

    defer SourceEvidence reindex pending bloat evidence
---
 ops/sourceevidence-maintenance.sql | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

diff --git a/ops/sourceevidence-maintenance.sql b/ops/sourceevidence-maintenance.sql
index 208a92e9..dc9c1a67 100644
--- a/ops/sourceevidence-maintenance.sql
+++ b/ops/sourceevidence-maintenance.sql
@@ -79,8 +79,12 @@ VACUUM (ANALYZE, VERBOSE) "SourceEvidence";
 -- a transaction), which is why they are listed individually.
 -- ---------------------------------------------------------------------------
 \echo '=== STEP 2: REINDEX INDEX CONCURRENTLY (edit the list per Step 0) ==='
-REINDEX INDEX CONCURRENTLY "SourceEvidence_entityType_entityId_idx";
-REINDEX INDEX CONCURRENTLY "SourceEvidence_stagedRecordId_idx";
+-- First-run disposition (2026-09-01 production preflight + DTD 3/3, post-review KEEP):
+-- all REINDEX statements remain disabled. The indexes are valid, exact bloat is unmeasured,
+-- and the volume is already 90% used. Enable ONE line only after evidence shows bloat and a
+-- separate gated preflight confirms enough scratch space for old+new copies.
+-- REINDEX INDEX CONCURRENTLY "SourceEvidence_entityType_entityId_idx";
+-- REINDEX INDEX CONCURRENTLY "SourceEvidence_stagedRecordId_idx";
 -- The PK is usually the largest index on this table. Rebuild it only if Step 0
 -- shows it bloated — a cuid PK on an insert-only table bloats slowly:
 -- REINDEX INDEX CONCURRENTLY "SourceEvidence_pkey";

← b9a44831 TK-10878: monthly SourceEvidence VACUUM/REINDEX maintenance · back to Homesonspec · TK-11125: add stableStringify + payloadHash canonical hash h 671fbb26 →