The Smart Read Replica: What It Is, and How It Knows What to Keep
A smart read replica keeps only the hot data your queries actually touch, instead of copying the whole database. Here is how PgCache decides what to keep.
Read more →Blog
Product updates, technical deep dives, and engineering insights.
PgCache licensing update: Elastic v2
Our license, and why we chose it.
Read more →Why Your 99% Cache Hit Ratio Is Still Crushing Your Postgres CPU
Caching results is not the same as caching data. It's also harder. We're building PgCache to make it easy.
Read more →PostgreSQL Logical Replication and Schema Changes
PostgreSQL logical replication does transmit schema information via Relation messages, but only when data is modified, not when DDL executes. This timing makes it problematic for read replicas but perfectly suited for caching systems.
Read more →PostgreSQL Query Optimizations
Examining how PostgreSQL's query optimizer has evolved from version 9.6 to 18.0, looking at three key SQL transformations.
Read more →Introducing PgCache: Transparent Caching for PostgreSQL
We're building PgCache to solve database caching once and for all. Here's why we started and what we're building.
Read more →