BASE 44 ORDER: Build lead_cache with 12 hash partitions + asyncpg pool + hourly VACUUM — E8 Intelligence Research

Abstract

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1270] Create lead_cache table partitioned by lead_hash % 12 into 12 hash partitions. Add Python SHA256-64bit hash function. Implement asyncpg pool with 12 workers, each querying/inserting its bucket. Add ON CONFLICT DO UPDATE. Schedule hourly VACUUM ANALYZE via systemd timer. MERLIN: Understood — this is a platform build directive. I'll create the lead_cache table with 12 hash partitions based on lead_hash % 12, add the SHA256-64bit Python hash function, and implement an asyncpg pool with 12 workers each bound to its bucket, using ON CONFLICT DO UPDATE. I'll also set up the systemd timer for hourly VACUUM ANALYZE and report back once the schema, pool, and timer are live. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com