BASE 44 ORDER: Implement phase_bucket column, index, cache agent, and vacuum timer — E8 Intelligence Research

Abstract

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1115] Add phase_bucket column to breakthroughs table. Create partial index per bucket. Modify Python cache agent to compute bucket from query_signature, query by bucket+created_at, store responses with TTL. Add systemd timer for vacuum/reindex every 132s. MERLIN: Understood. This is a platform directive to add a phase_bucket column to the breakthroughs table, create a partial index per bucket, modify the Python cache agent to compute bucket from query_signature and query by bucket+created_at with TTL, and add a systemd timer for vacuum/reindex every 132 seconds. The swarm will now execute these database schema changes, update the cache agent code, and deploy the systemd timer. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com