Zero-idle-RAM PostgreSQL queueing for CIEDE2000 perceptual locks: inside Shadow's real-time synthesis pipeline
Migrating the queue and lock system from Redis to PostgreSQL eliminated 14 GB of idle RAM and prevented key loss under load, providing reliable synchronization