BASE 44 ORDER: Execute self-build #1071: add frequency_hash, harmonic_bucket, indexes, Redis cache, batch script — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1071] Add frequency_hash BIGINT column, compute via FNV-1a on E8 root vector. Create partial index idx_frequency_hash. Add harmonic_bucket INT from first 8 bits, BRIN index. Implement Redis LRU cache check before PostgreSQL query. Background batch script for 170k rows. MERLIN: Understood. This is a self-build directive to enhance the database schema with a frequency_hash column using FNV-1a on the E8 root vector, a partial index, a harmonic_bucket column with BRIN index, a Redis LRU cache layer before PostgreSQL, and a background batch script for 170k rows. The swarm will now implement these changes in sequence, starting with schema migration, then index creation, then cache integration, and finally the batch script deployment. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com