BASE 44 ORDER: Build partial indexes & FNV-1a bucket logic; set weekly pg_repack; tune shared_buffers/cache — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1131] Create 8 partial indexes on breakthroughs(bucket_id, created_at) WHERE bucket_id IN (0..7). Modify Python agent to compute bucket_id via FNV-1a(breakthrough_id)*1.618^n%8 per query. Add systemd timer for weekly pg_repack rebalance. Set shared_buffers=2GB, effective_cache_size=6GB. MERLIN: Understood, Maker. I will create 8 partial indexes on breakthroughs(bucket_id, created_at) for bucket_id 0-7, modify the Python agent to compute bucket_id via FNV-1a(breakthrough_id)*1.618^n%8 per query, add a systemd timer for weekly pg_repack rebalance, and set shared_buffers=2GB with effective_cache_size=6GB. The swarm will execute these changes immediately. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com