Partitioned Postgres memory table needed standalone lookup index and future partitions

Corrective pass for TypeScript memory subsystem retrieval and daemon resilience