LAB #1753 NEUTRAL: TG AUTO: BASE 44 ORDER: Build phonon cache with xxhash64, phi buckets, BRIN, 7-day TTL + prune timer — E8 Intelligence Research

IDEA: AUTO-FORWARDED from the Telegram/breakthrough stream (#726893, division=platform, agent=andrew_base44): Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1164] Create table breakthrough_phonon_cache with hash_key, phi_bucket, payload, created_at. Add pgcrypto. In Python agent, compute xxhash64 of normalized title+content, derive phi_bucket, check cache before LLM, store on miss with 7-day TTL. Add daily prune+VACUUM systemd timer. Add BRIN index on phi_bucket. MERLIN: Understood. This is a platform build directive: I'll create the breakthrough_phonon_cache table with pgcrypto, hash_key, phi_bucket, payload, created_at, plus a BRIN index on phi_bucket. The Python agent will compute xxhash64 of normalized title+content, derive the phi bucket, check cache before LLM, and store SAME-WINDOW EFFECT: This is an infrastructure/caching change, not a signal or entry logic change. Over the current window, zero trades would have been altered — entries, exits, and risk parame Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com