Advanced Distributed Caching Layer for Query Acceleration

Develop a PostgreSQL caching strategy for a high-traffic API service that reduces database load while maintaining near-real-time data consistency. Create a sophisticated stored procedure that implements intelligent cache invalidation, handles race conditions, and supports dynamic cache warming for frequently accessed datasets. Include mechanisms for tracking cache hit rates, automatic cache key generation, and handling complex nested object caching.