# NousResearch/hermes-agent · Trigram FTS index bloat and opt-out controls

## Open now

- 0 issues, 1 PR open on GitHub.
- PR #68394: feat(state): add sessions.trigram_fts config flag to disable the trigram FTS index

These items address excessive state.db size caused by trigram full-text search indexes, and introduce various config flags, environment variables, and storage layout changes to allow disabling or reducing those indexes.

## TL;DR

- 6 member(s): 0 open issue(s), 2 closed issue(s), 1 open PR(s), 1 merged PR(s), 2 PR(s) closed without merging.
- A fix was merged to main in PR #65798. Verify it addresses your case.
- **Recommended:** read PR #65798 (and any competing PRs below) before filing. Confirm the merged change covers your symptom.

## Maintainer resolution verdict

- Internal-tracker verdict over this cluster's issue members: `resolved` · deciding PR(s): `pr-65798`. This is distinct from the fix status above. Weigh it yourself.

## How this cluster was grouped

- Link evidence (`STRUCTURAL_SPANNING`): every member is connected by structural evidence: shared changed files, or a closing/superseded reference.
- Pairwise link density `0.36`: the share of member pairs that carry a link, counting a structural link in full and a relevance-only link at 0.36. `1.00` means every pair is linked.

## Closed / duplicate issues

- #22478: state.db FTS trigram index bloat: 70% of DB size is full-text indexes
- #55233: Add config flag to disable trigram FTS index (prevent state.db bloat)

## Prior & competing PRs

- **#65798: perf(state): compact v23 FTS layout — external-content indexes, tool-row-free trigram, opt-in \`hermes sessions optimize-storage\`**. merged to main · fix tier `verified`
  - maintainer direction: category `merged`
  - files: `.github/actions/detect-changes/action.yml`, `.github/actions/get-app-token/action.yml`, `.github/workflows/ci.yml`, `.github/workflows/contributor-check.yml`, `.github/workflows/deploy-site.yml`, `.github/workflows/e2e-desktop.yml`, `.github/workflows/history-check.yml`, `.github/workflows/js-autofix.yml`, `.github/workflows/label-rerun.yml`, `.github/workflows/lint.yml`, `.github/workflows/lockfile-diff.yml`, `.github/workflows/osv-scanner.yml`, `.github/workflows/review-labels.yml`, `.github/workflows/skills-index-freshness.yml`, `.github/workflows/skills-index.yml`, `.github/workflows/supply-chain-audit.yml`, `.github/workflows/upload_to_pypi.yml`, `.github/workflows/uv-lockfile-check.yml`, `.gitignore`, `Dockerfile` (+1196 more)
- **#42190: fix(state): honour HERMES_DISABLE_FTS_TRIGRAM to skip CJK index**. closed without merge
  - maintainer direction: category `uncategorized`; implication `needs_llm`; refs `e2e0a8628aec`, `#22478`
- **#68089: feat(state): add config.yaml flag to disable trigram FTS index**. closed without merge
  - maintainer direction: category `silent_close`; implication `active`
- **#68394: feat(state): add sessions.trigram_fts config flag to disable the trigram FTS index**. open
  - maintainer direction: category `implemented_elsewhere`; implication `superseded`; refs `#102032`
  - files: `hermes_cli/config.py`, `hermes_state.py`, `tests/test_hermes_state.py`, `website/docs/user-guide/sessions.md`

## Fix status

- Merged to main in PR #65798 (cited above). No release data is tracked. Verify downstream.
- Fix last verified (merged) `2026-07-22`.
- Subsystem: `agent`