An independent benchmark by Hulunlante Worku, testing PgCache 0.6.2 against a 16-million-row dataset: 2.9s to 0.6ms on a 10M-row join, and no measurable difference on point lookups. Warm cache against warm cache, with every filter and join column indexed first.
How PgCache uses the logical replication stream as a change feed to keep cached query results synchronized with the origin database — no manual cache invalidation logic required.
A wire-compatible PostgreSQL proxy that caches read queries and maintains freshness through logical replication, caching only frequently accessed data and updating results automatically when the underlying data changes.