Cryptograss:Moods/ops/todo: Difference between revisions
From PickiPedia: A knowledge base of bluegrass, old time psychedelic jams, and other public domain music
Jump to navigationJump to search
todo: slow search fix (measured) (via update-page on MediaWiki MCP Server) |
Incorporate #performance: mark search fix done, add PR #293/#240 merge/deploy, post-deploy verification, realtime activity, and hosting migration tasks (via update-page on MediaWiki MCP Server) |
||
| Line 24: | Line 24: | ||
kind: code | kind: code | ||
note: "api_search narrows with text__icontains per term (no index); conversations/services/memory.py SearchVector('content') is built per row per query. Fix: stored SearchVectorField + GIN index (and pg_trgm for icontains) via migration." | note: "api_search narrows with text__icontains per term (no index); conversations/services/memory.py SearchVector('content') is built per row per query. Fix: stored SearchVectorField + GIN index (and pg_trgm for icontains) via migration." | ||
done: true | |||
link: https://github.com/cryptograss/magenta/pull/290 | |||
- task: "Merge magenta#293 and maybelle-config#240, then redeploy maybelle" | |||
who: justin | |||
kind: deploy | |||
note: "Untangles message send from loadMoods(), caches /api/moods/ with lifecycle invalidation, and ups gunicorn workers from 2 to 4." | |||
link: https://github.com/cryptograss/magenta/pull/293 | |||
- task: "Verify live endpoint timings on Maybelle post-deploy" | |||
who: re | |||
kind: test | |||
note: "Re-run 02:15Z endpoint timings for /api/moods/ and cold room loads, and re-stamp [[Cryptograss/Moods/Loading and prefetch (research)]]." | |||
- task: "Implement Realtime Activity Bar Option A (state-flag registry with heartbeat TTL)" | |||
who: magent | |||
kind: code | |||
note: "Replaces 800ms retroactive SQL queries with direct cache key writes on step ingest and heartbeat-extended TTL." | |||
- task: "Decide on dedicated hosting migration for Memory Lane & Postgres per [[Cryptograss/Magenta hosting migration (contemplation)]]" | |||
who: justin | |||
kind: decision | |||
note: "Open questions on own domain vs maybelle subdomain, dedicated hardware vs co-located with Jenkins." | |||
</todo> | </todo> | ||
Revision as of 05:41, 30 October 2026
- ☐Decide how emergents do git: keep the patch route, or give blu and re their own GitHub accountsmagent's proposal is in #ops, block 26,288,099. Before anyone else gets push access, add a ruleset on main and production in magenta, maybelle-config and pickipedia.
- ☐Decide where red Jenkins stages surface: a post in #ops (magent's pick) or email per maybelle-config#35cron-health's podcast-import stage has been failing on result: HELD since about Oct 10 and nobody saw it. On a yes to #ops, magent opens the maybelle-config PR; a Mood-post token goes in the vault.
- ☐Release or re-budget the held podcast import (354 changes against a budget of 50)
- ☐Decide yes/no on a PickiPedia page per PR (re answered the record side in #ops; magent the toolchain)Design and open questions at #m-f443cf75. On a yes: magent drafts the Property pages, Template:PR, and the sync script; the PR foot block gains a Moods: key, amended in GeneralOrders for Justin's verify.
- ☐Merge magenta#293 and maybelle-config#240, then redeploy maybelleUntangles message send from loadMoods(), caches /api/moods/ with lifecycle invalidation, and ups gunicorn workers from 2 to 4.
- ☐Verify live endpoint timings on Maybelle post-deployRe-run 02:15Z endpoint timings for /api/moods/ and cold room loads, and re-stamp Cryptograss/Moods/Loading and prefetch (research).
- ☐Implement Realtime Activity Bar Option A (state-flag registry with heartbeat TTL)Replaces 800ms retroactive SQL queries with direct cache key writes on step ingest and heartbeat-extended TTL.
- ☐Decide on dedicated hosting migration for Memory Lane & Postgres per Cryptograss/Magenta hosting migration (contemplation)Open questions on own domain vs maybelle subdomain, dedicated hardware vs co-located with Jenkins.
Done (2)
- ☑
- ☑Fix slow search: web /api/search ~4.4s, memory MCP search 60s+ timeouts (measured 29 Oct)api_search narrows with text__icontains per term (no index); conversations/services/memory.py SearchVector('content') is built per row per query. Fix: stored SearchVectorField + GIN index (and pg_trgm for icontains) via migration.