dot-iu-cutter v0.5 — Pre-Scale Index-Only DDL Authoring Report (routes to GPT; nothing executed) (2026-05-17)
dot-iu-cutter v0.5 — Pre-Scale Index-Only DDL Authoring Report
Date: 2026-05-17 · Status: AUTHORING ONLY — nothing executed; routes the package to GPT.
Phase: GPT PASS of v0.5 pre-scale foundation → sequencing step 1 = pre-scale index-only DDL authoring. Execution (dry-run, then production) is a separate later cycle, NOT authorized.
Accepted code commit: e93424b5ff7fa5e4b8406131977ce4339cd0856a (branch main, iu-cutter clean).
1. Package (5 docs, …/v0.5-pre-scale-index-ddl-authoring/)
…-ddl-draft-…sql.md— 7 deterministic CONCURRENTLY indexes (+ isolated non-concurrent dry-run variant), partial-vs-full decided.…-verification-plan-…— structural catalog gates V-1…V-8 + additive A-1…A-5 (no rendered-string compare).…-rollback-plan-…—DROP INDEX CONCURRENTLY IF EXISTSexact-name, no CASCADE.…-risk-review-note-…— LOW–STANDARD; R-1…R-9 mitigated.- this report.
Read-only grounding only (column nullability, name-collision check, baselines). No index, dry-run, write, code, commit.
2. The 7 indexes (1:1 with GPT hot-path list)
| Hot path | Index | Form |
|---|---|---|
| SWEEP cursor | idx_dbe_status_emitted_keyset on decision_backlog_entry(status,emitted_at,entry_id) |
full composite btree (all NOT NULL) |
| lineage | idx_me_source_doc_ref on manifest_envelope(source_doc_ref) |
full btree (NOT NULL) |
| lineage/review | idx_rd_manifest_id on review_decision(manifest_id) |
full btree (NOT NULL) |
| cut-once guard | idx_ccs_dbe_id on cut_change_set(decision_backlog_entry_id) |
partial WHERE … IS NOT NULL (nullable) |
| verify lookup | idx_vr_change_set_id on verify_result(change_set_id) |
full btree (NOT NULL) |
| DOT executor xref | idx_dps_xref_cs on dot_pair_signature(cross_reference_change_set_id) |
partial WHERE … IS NOT NULL (nullable/XOR) |
| DOT verifier xref | idx_dps_xref_vr on dot_pair_signature(cross_reference_verify_result_id) |
partial WHERE … IS NOT NULL (nullable/XOR) |
3. Decisions
- D-1 exact index set = the 7 above (= GPT's list). Made.
- D-2 partial vs full for nullable refs = partial for the 3 nullable (planner uses it for
col=$1; excludes large NULL fraction). Recommended; escalated for GPT confirm vs full. - D-3 CIC transaction model = standalone statements, autocommit, no BEGIN, per-statement; INVALID-on-failure handled by drop+retry. Made & documented.
- D-4 rollback =
DROP INDEX CONCURRENTLY IF EXISTSexact-name, no CASCADE, not in txn. Made. - D-5 production command model = a later separate dry-run → command-review → sovereign cycle. Deferred/escalated.
4. Constraints honoured
Index-only · no table/column/constraint/trigger/function/RLS/default-privilege creation · no data DML · no label registry · no vector/NoSQL · CONCURRENTLY for the production model · transaction/concurrency limits documented · deterministic names · verification = structural catalog (not rendered string).
5. Git / hardcode / boundaries
- Git: branch
main· HEADe93424b5ff7fa5e4b8406131977ce4339cd0856a·git status --short -- iu-cutter= clean (0 lines) — no code change, no commit (none expected/authorized). - No fixed IP/DSN/password/container/vector-collection; no runtime label/key hardcoding; no new label columns; SQL = SSOT.
- Still forbidden & not done: index execution · dry-run execution · production writes · CUT/VERIFY · second IU / bulk cut · label registry schema · tier-normalization write · JSONB normalization · vector/NoSQL · deploy/restart · alias writes.
6. Next
GPT review of this index-DDL authoring package + ruling on D-2 (partial vs full) and D-5. On PASS, the next sequenced step is the index-DDL dry-run then production execution cycle (its own command-review + sovereign prompt) — then dry-run-at-volume, tier normalization (if needed), label/metadata registry design, Hiến pháp source ingestion design, Hiến pháp dry-run → staged production. Self-advance PROHIBITED.