Enhancement: Promote time-series indexes

[smiggleworth]

Audit classification

• Type: Enhancement
• Affected subsystem: Analytical and time-series workloads
• User/operator impact: The capability may exist only as Experimental or an unverified path, limiting operator confidence and making production support boundaries unclear.
• Current behavior: The relevant implementation or workflow is not yet promoted to the requested support level; existing behavior remains bounded by its documented status and evidence.
• Expected behavior/outcome: Verify the behavior against explicit promotion criteria, document supported and unsupported cases, and promote it only when the acceptance criteria are met.
• Deterministic evidence: Source-of-truth: the issue's linked repository documentation, tests, workflows, and benchmark contracts; baseline commit afb23d0. The existing scope and acceptance criteria below are the deterministic work record.
• Confidence and support status: Medium to high, based on repository documentation and existing contracts.; Experimental or promotion candidate; not a claimed bug.
• Related tracker: Audit: Cassie engine and Admin UI/UX gap backlog at afb23d0 #1

Scope

Complete time-series index promotion evidence across bucket widths and lifecycle operations.

Source of truth

docs/experimental-promotion-criteria.md:20-31.

Acceptance criteria

• Cover range planning, mutation/delete/retention correctness, restart hydration, and bucket fallback diagnostics.
• Add benchmark evidence across supported bucket widths and declared fixture sizes.
• Prove stale/missing/corrupt sidecar behavior returns authoritative results.
• Update support/readiness status only after common promotion gates pass.

Tracking: #1.

[smiggleworth]

Grouped in PR #44 (#44): promotion evidence matrix records existing local tests, missing same-commit or hosted evidence, and explicit unsupported boundaries. The surface remains not promoted until its row's gates are met.

[smiggleworth]

Local-only acceptance update: time-series range planning, mutation/delete/retention cleanup, restart hydration, bucket fallback, concurrency, and metrics tests pass locally.

[smiggleworth]

Full-history re-audit at current main d0874ff: docs/promotion-evidence-matrix.md explicitly marks issue #27 Not promoted and names missing closure evidence. The prior close recorded only a local correctness slice, while the original issue requires promotion evidence and a support/readiness update. Remaining criteria: retained benchmark evidence across supported bucket widths and dependent retention windows. Dependency: #7 and/or the relevant compatibility or deployment-profile evidence lane. Next action: retain the named evidence, re-run the focused and full validation gates, and update Feature Support only if every common promotion criterion passes.

[smiggleworth]

Current-main re-audit at : range planning, mutation/delete/retention cleanup, restart hydration, missing/stale/corrupt sidecar fallback to authoritative rows, concurrency, and metrics have deterministic coverage. The missing promotion gate is retained benchmark evidence across supported bucket widths, declared fixture sizes, and dependent retention windows. Canonical run 32505662069 failed before the relevant later owners completed; PR #158 repairs the upstream Tier 3 blocker but is not yet merged or evidenced.\n\nDisposition: keep #27 open and time-series access Experimental. Dependency: #7 / PR #158 followed by a passing unfiltered same-commit artifact. Inspect every bucket-width/retention row, normalization, read bounds, trust/noise, fixture identity, and deployment metadata before any support/readiness change.

[smiggleworth]

Correction to the immediately preceding comment: shell rendering stripped the current-main SHA. The audited revision is 8b84ee936986f586567530a2decee949d2b8f14c.

At that revision, range planning, mutation/delete/retention cleanup, restart hydration, missing/stale/corrupt sidecar fallback to authoritative rows, concurrency, and metrics have deterministic coverage. The missing promotion gate is retained benchmark evidence across supported bucket widths, declared fixture sizes, and dependent retention windows. Canonical run 32505662069 failed before the relevant later owners completed; PR #158 repairs the upstream Tier 3 blocker but is not yet merged or evidenced.

Disposition: keep #27 open and time-series access Experimental. Dependency: #7 / PR #158 followed by a passing unfiltered same-commit artifact. Inspect every bucket-width/retention row, normalization, read bounds, trust/noise, fixture identity, and deployment metadata before any support/readiness change.