NousResearch/hermes-agent

FTS trash table deletion O(n²) performance fix

Cluster 79324. Data as of

Nothing open on GitHub. Fix merged in #81043 on 7 Aug 2026. Check it covers your case.

The short answer

0open issues
0open PRs
3items grouped
Known?
Yes. 3 related items grouped here, 1 issue already closed.
Fix event
A fix was merged to main in PR #81043. Check it covers your case. No release data is tracked.
Tracker
The maintainers' tracker marks this resolved, deciding PR #81043. That is separate from the fix event.
Still open
Nothing open on GitHub.

A performance issue was identified where FTS trash table cleanup used a DELETE...IN(SELECT...LIMIT N) pattern that scaled quadratically on large tables. A proposed fix replaces the re-scanning approach with a high-water marker strategy.

Open issues0

No open issues.

Open PRs0

No open pull requests.

Fixes on record

Merged to main. A stamp counts the issues a fix is linked to.

  • #81043 perf(fts): drain trash tables with a high-water marker instead of re-scanning

    merged to main

    files: hermes_state_search.py, tests/test_hermes_state.py

1 PR closed without merging

From the close comments: merged via another change 1

  • #79359 perf(fts): drain trash tables with a high-water marker instead of re-scanning · merged via another change → #81043
Closed issues · 1
  • Closed#79324[Perf]: _fts_teardown_trash_step DELETE ... IN (SELECT ... LIMIT N) is O(n²) on large trash tables
How this cluster was grouped
  • Link evidence (structural links throughout): every member is connected by structural evidence: shared changed files, or a closing/superseded reference.
  • Pairwise link density 0.67: the share of item 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.

Pick up a Lab task

Check whether a fix covers the open issues here, with your own agent. Bring back evidence for maintainers.

Open the Lab

At a glance

Merged PRs
#81043
Closed issues
1
Attempts
1 PR closed without merging
Fix link checked
7 Aug 2026

For your agent

The same facts, typed.