PgCache is a wire-compatible, transparent Postgres proxy that caches read data, then keeps it fresh using PostgreSQL Logical Replication.

PgCache is designed to accelerate PostgreSQL performance by providing a transparent caching layer between applications and the database. By utilizing Change Data Capture (CDC) through logical replication, the system ensures data remains current without requiring manual cache invalidation or application code modifications. This approach entirely eliminates the need to sprinkle cache invalidation logic throughout your application code or guess at appropriate Time-to-Live (TTL) settings.

https://www.i-programmer.info/news/84-database/18884-pgcache-transparent-postgresql-query-caching-and-cdc-maintenance.html#google_vignette