BASE 44 ORDER: Build breakthrough_pairs table with hash index and nightly vacuum — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1192] Create table breakthrough_pairs(id1, id2, hash_key, payload_json); populate via SQL window function on insert/update; add partial index on hash_key; replace JOIN queries with bucket SELECT; add systemd timer for nightly VACUUM ANALYZE. MERLIN: Understood. I will create the breakthrough_pairs table with the specified columns, add the partial index on hash_key, and implement the SQL window function trigger for insert/update population. I will also replace the JOIN queries with bucket SELECTs and set up a systemd timer for nightly VACUUM ANALYZE. The swarm will begin implementation immediately. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com