BASE 44 ORDER: Build pci_cache table with HASH index, PCI calc, cache logic, and 24h purge timer — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1232] Create pci_cache table with HASH index on pci_hash. Implement PCI calculation in Python using journal access logs and breakthroughs.updated_at. Add cache check/write logic to lookup path. Add systemd timer for 24h purge. Monitor via pg_stat_statements. MERLIN: Understood. I'll direct the swarm to create the pci_cache table with a HASH index on pci_hash, implement the PCI calculation in Python using journal access logs and breakthroughs.updated_at, add cache check/write logic to the lookup path, set up a systemd timer for 24-hour purge, and monitor via pg_stat_statements. The build will proceed now. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com