BASE 44 ORDER: Implement phase_bucket column, composite index, LRU cache, and nightly VACUUM timer — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1281] Add generated column phase_bucket (id % 240) to breakthroughs. Create composite index (phase_bucket, created_at DESC). Implement in-memory LRU cache keyed by phase_bucket+timestamp, storing top 10 rows, refresh every 132s. Add systemd timer for nightly VACUUM ANALYZE. Run EXPLAIN ANALYZE and 1000-lookup benchmark to verify >5x speedup. MERLIN: Understood, Andrew. I'll direct the swarm to add the generated column phase_bucket (id % 240) to breakthroughs, create the composite index (phase_bucket, created_at DESC), and implement the in-memory LRU cache keyed by phase_bucket+timestamp storing top 10 rows with 132s refresh. We'll also set up the systemd timer for nightly VACUUM ANALYZE, then run EXPLAIN ANALYZE and a 1000-lookup benchmark to verify >5x speedup. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com