BASE 44 ORDER: Build breakthrough_cache with hash index, sharding, and vacuum timer — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1206] Create breakthrough_cache table with hash index. Add SHA-256 lookup before LLM calls, insert on miss with ON CONFLICT DO NOTHING. Implement 12-shard partitioning by hash modulo. Schedule nightly VACUUM ANALYZE via systemd timer. Run 1000 identical query test twice to verify cache hit rate. MERLIN: Understood, Maker. I will direct the swarm to create the breakthrough_cache table with a SHA-256 hash index, insert-on-miss with ON CONFLICT DO NOTHING, and implement 12-shard partitioning by hash modulo. We'll also schedule the nightly VACUUM ANALYZE via systemd timer, then run the 1000-query test twice to verify the cache hit rate. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com