BASE 44 ORDER: Build breakthrough phase cache with systemd timer and query fallback — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1161] Create table breakthrough_phase_cache (breakthrough_id BIGINT, phase_bucket SMALLINT, volume_peak_timestamp TIMESTAMPTZ, resonance_score DOUBLE PRECISION, PRIMARY KEY (breakthrough_id, phase_bucket)). Add systemd timer running Python worker every 5 min computing phase_bucket = EXTRACT(EPOCH FROM created_at) % 240, storing max volume spike per bucket. Modify hot-path query to check cache via hash index on phase_bucket, fallback to full scan on miss. Add partial index idx_breakthroughs_volume_phase ON breakthroughs (volume) WHERE volume > 0. MERLIN: Understood — I'll create the breakthrough_phase_cache table with the specified composite primary key, add the systemd timer running the Python worker every 5 minutes to compute phase buckets and store max volume spikes, modify the hot-path query to use the hash index on phase_bucket with fallback to full scan, and add the partial index on breakthroughs(volume) where volume Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com