Sign in

PgCache 🐘🦀

@pgcache.bsky.social
42 followers 186 following 68 posts

Smart Read Replica for Postgres. Drop-in. Automatically caches hot data. Keeps it fresh with CDC. Early Access (AWS AMI): aws.amazon.com/marketplace/pp/prodv… Community: discord.gg/n4Mrr7DgB4

PostsRepliesMedia
PgCache 🐘🦀 @pgcache.bsky.social · 25/09/2026
Which Postgres queries are worth caching? We shared a free online Postgres tool on Reddit yesterday. 26k views and 180 shares so far! The idea behind it is pretty simple: rank your queries by total time vs what "feels slow."
100
Reposted by PgCache 🐘🦀
Postgres Summit US @pgsummitus.bsky.social · 20/09/2026
Still on the fence about attending Postgres Summit US? Not sure how to approach your manager about conference expenses? We make it easy! Check out our “Make the Case” page. It contains all the information you need! 2026.postgressummit.us/attend/justi... #PostgreSQL #postgres #conference
045
PgCache 🐘🦀 @pgcache.bsky.social · 21/09/2026
we'll be there!
000
PgCache 🐘🦀 @pgcache.bsky.social · 21/09/2026
Already decided Postgres needs a cache? You don't have to build it into your app. PgCache sits between your app and Postgres and caches your hot reads. Swap the connection string. No cache code, no TTL to guess at. See if your workload fits: pgcache.com/fit #PostgreSQL
Card with a PSA tag and large text: STOP! Don't build that cache. No app changes. No TTLs. PgCache logo and pgcache.com at the bottom.
000
PgCache 🐘🦀 @pgcache.bsky.social · 16/09/2026
We built PgCache but we've never met (yet!) That'll change when we head to NYC in a couple weeks for @pgsummitus.bsky.social 🎉🐘 If you're in SoHo 9/30 to 10/2, and want to grab a coffee, send us DM and we'd love to connect!
000
PgCache 🐘🦀 @pgcache.bsky.social · 10/09/2026
Don't wonder if caching might help. Find out. Takes < 1 min (locally in browser via WebAssembly). Check it out at pgcache[.]com/fit
000
PgCache 🐘🦀 @pgcache.bsky.social · 09/09/2026
You probably don't need another read replica. What you probably need is the answer to this question: "how much of our read traffic can be cached?" Check yours for free in 2 minutes, locally in your browser, at pgcache [dot] com/fit.
000
PgCache 🐘🦀 @pgcache.bsky.social · 08/09/2026
We see a third path for scaling reads on PostgreSQL Path 1 - Read replicas & server upgrades. Path 2 - External caches. Path 3 - CDC-driven smart read replicas. We saw what's possible with PostgreSQL Logical Replication, and thought "it doesn't have to be this complicated."
001
PgCache 🐘🦀 @pgcache.bsky.social · 02/09/2026
Hulunlante Worku built an independent PgCache benchmark. Custom ecomm workload and some slick design choices. Check it out! No diff on point lookup speed (not our focus)... But he saw 2.9 seconds -> 0.6 ms on a 10M-row join 🔥 Thanks Hulu! Great post. dev.to/huluwz/how-i...
dev.to
How I Put PgCache in Front of a 16-Million-Row Postgres Database
Real speedups, one slow startup window, and a healthcheck that lied to me. A hands-on benchmark of PgCache 0.6.2 a CDC-backed Postgres caching proxy.
000
PgCache 🐘🦀 @pgcache.bsky.social · 01/09/2026
Independent benchmark of PgCache. 16M rows, published in full. No difference for point lookups, because that's not what we're solving for (0.3ms → 0.3ms). But that 10M-row join? 2.9s → 0.6ms 🔥 And we passed the freshness test, too. Unpaid, unaffiliated, MIT repo: dev.to/huluwz/how-i...
dev.to
How I Put PgCache in Front of a 16-Million-Row Postgres Database
Real speedups, one slow startup window, and a healthcheck that lied to me. A hands-on benchmark of PgCache 0.6.2 a CDC-backed Postgres caching proxy.
000
PgCache 🐘🦀 @pgcache.bsky.social · 26/08/2026
In the age of Logical Replication there's simply no reason a human or agent should have to manually configure invalidation, TTLs ... much less decide which queries get cached. PgCache does better, automaticall. Check out our benchmark harness. github.com/PgCache/pgca...
github.com
GitHub - PgCache/pgcache-bench
Contribute to PgCache/pgcache-bench development by creating an account on GitHub.
000
PgCache 🐘🦀 @pgcache.bsky.social · 25/08/2026
@tempest98.bsky.social did some PgCache benchmarking, with very interesting results that we shared out last week. But don't take our word for it, he just published the harness he used. Take it for a spin, let us know what you think! github.com/PgCache/pgca...
github.com
GitHub - PgCache/pgcache-bench
Contribute to PgCache/pgcache-bench development by creating an account on GitHub.
000
PgCache 🐘🦀 @pgcache.bsky.social · 19/08/2026
our talk is today at 9AM PT! Come for the Logical Replication vibes ... Stay for the surprising benefits of caching PostgreSQL data, instead of results! Today is the best opportunity yet to learn about PgCache, and to ask the founding team your questions. www.meetup.com/postgres-mee...
meetup.com
Logical replication is for more than just ETL: building PgCache, Wed, Aug 19, 2026, 12:00 PM | Meetup
This meetup will introduce PgCache, a new Postgres project for caching hot data. Think of it as a smart read replica. The project founders James Nelson and Philip Johnston
000
PgCache 🐘🦀 @pgcache.bsky.social · 19/08/2026
Some updates to the PgCache website: www.pgcache.com check it out! 👉and don't forget to sign up for our talk tomorrow: Postgres Meetup for All: "Logical Replication is for more than ETL: building PgCache" 9AM PT / 4PM UTC www.meetup.com/postgres-mee...
pgcache.com
PgCache - Smart Read Replica for PostgreSQL
PgCache is a smart read replica for PostgreSQL that caches the hot data driving most of your traffic. Cut read-replica storage, compute, and Aurora IO costs without code changes.
000
PgCache 🐘🦀 @pgcache.bsky.social · 17/08/2026
"Logical replication is for more than just ETL" If PostgreSQL replication, caching, and optimization are things you pay attention to... ...then consider this is a friendly neighborhood reminder to join us on Wednesday 8/19 at 9am PT / 4PM UTC 🦀🐘⚡
010
PgCache 🐘🦀 @pgcache.bsky.social · 06/08/2026
When we started PgCache, the goal was: Build an easier cache for Postgres. Didn't expect folks to be so interested with how we're using PostgreSQL Logical Replication to do that. Join us on 8/19 at 9AM PT on Postgres Meetup for All for the inside scoop: www.meetup.com/postgres-mee...
meetup.com
Logical replication is for more than just ETL: building PgCache, Wed, Aug 19, 2026, 12:00 PM | Meetup
This meetup will introduce PgCache, a new Postgres project for caching hot data. Think of it as a smart read replica. The project founders James Nelson and Philip Johnston
000
PgCache 🐘🦀 @pgcache.bsky.social · 31/07/2026
The founding team will be presenting on PgCache at Postgres Meetup for All 🐘 Wednesday, August 19 at 9AM PST / 12PM EST. - current status - how we got started, and - surprising discoveries from a year building on PostgreSQL signup here: www.meetup.com/postgres-mee...
meetup.com
Logical replication is for more than just ETL: building PgCache, Wed, Aug 19, 2026, 12:00 PM | Meetup
This meetup will introduce PgCache, a new Postgres project for caching hot data. Think of it as a smart read replica. The project founders James Nelson and Philip Johnston
000
PgCache 🐘🦀 @pgcache.bsky.social · 30/07/2026
2 vCPU PgCache in front of RDS, 27M rows of Stack Exchange data. read-only: origin CPU 70% to 3%. throughput 5-6x. p50 15ms to 2.5ms. If you're running a heavy read-only workload on Postgres and want to make things easier for origin ... DM me.
000
PgCache 🐘🦀 @pgcache.bsky.social · 29/07/2026
Our friend Kate Gawron built a white-label demand response app for a hackathon, and threw PgCache into the stack. Five grid operators, multi-tenant across four countries, and 489 unit tests is not too shabby for a hackathon build! kategawron.co.uk/2026/06/i-bu...
kategawron.co.uk
Kate, Cloud DBA: Expert Insights on Cloud Database Solutions
Expert Cloud DBA delivering insights on AWS, GCP, RDS & Cloud SQL for seamless cloud database management solutions.
000
PgCache 🐘🦀 @pgcache.bsky.social · 28/07/2026
PgCache doesn't just relay data to users: it keeps a conversation going with origin. I don't know of anyone else doing this for Postgres full blog post👇 www.pgcache.com/blog/postgre...
pgcache.com
The Postgres Dividend, or How Being Postgres-First Solves Most Hard Cache Problems
We bet early that the right way to cache Postgres was to do it in Postgres. Every hard problem we've encountered since then, that bet keeps paying us back.
000
PgCache 🐘🦀 @pgcache.bsky.social · 01/07/2026
@supabase.com's news outlet wrote a piece about us 👀 www.thereadreplica.com/news/logical...
thereadreplica.com
Postgres' Logical Replication Stream Gets A Second Life As A Cache Invalidation Engine
Two co-founders building a Postgres caching proxy discovered that logical replication is a better invalidation mechanism than anything the caching ecosystem has come up with on its own. The hard part ...
000
PgCache 🐘🦀 @pgcache.bsky.social · 26/06/2026
Caching is a bit of a cognitive monolith All of read optimization is. People don't think about it, deeply. They just default to full read replicas, or redis. We're making it better. The goal: You never have to think about your optimization layer again. www.thereadreplica.com/news/logical...
000
PgCache 🐘🦀 @pgcache.bsky.social · 22/06/2026
The whole way that we've been trained to think about read optimization is broken. Since PostgreSQL 10 and the introduction of Logical Replication, there's no good reason that most people running PostgreSQL at scale should have to think about read optimization
000
PgCache 🐘🦀 @pgcache.bsky.social · 19/06/2026
We bet early that the right way to cache Postgres was to do it in Postgres. Every hard problem we've encountered since then, that bet keeps paying us back. www.pgcache.com/blog/postgre...
020
PgCache 🐘🦀 @pgcache.bsky.social · 18/06/2026
Most caches are built to work with any database, then adapted to Postgres-specific features after the fact. If you're running Postgres, the database-specific features are usually the ones that matter most. PgCache is PostgreSQL first by design.
000
PgCache 🐘🦀 @pgcache.bsky.social · 12/06/2026
PgCache v0.5.0 + v0.6.0 shipped. Cache population and the CDC stream are two writers seeing the origin at different points on the replication timeline. We now coordinate them with LSNs so nothing stale slips in. Plus an in-memory response cache. github.com/PgCache/pgcache
github.com
GitHub - PgCache/pgcache: PostgreSQL proxy for query aware caching, using CDC for cache maintenance.
PostgreSQL proxy for query aware caching, using CDC for cache maintenance. - PgCache/pgcache
000
PgCache 🐘🦀 @pgcache.bsky.social · 08/06/2026
PgCache PSA: We discovered a consistency issue related to query population and CDC stream coordination. We're working on it. If you've tried PgCache in the past 4-5 months and seen some issues .. we now have a good idea as to why! Cutting a new version soon with a fix 🩹
010
PgCache 🐘🦀 @pgcache.bsky.social · 29/05/2026
James shipped PgCache v0.4.11 a couple weeks ago. The headline change was unglamorous but matters: better query fingerprinting. WHERE x = 1 + 2 now caches the same as WHERE x = 3 Why this is more important than it sounds
210
PgCache 🐘🦀 @pgcache.bsky.social · 27/05/2026
no middle gear in most postgres stacks today. you either run a full read replica or you don't. nothing in between. most teams need the in-between: scale without paying to duplicate every cold table. what am i missing?
000
PgCache 🐘🦀 @pgcache.bsky.social · 14/05/2026
a traditional read replica copies your whole database because it has no idea what you actually read. a smart one watches the query traffic and caches what gets hit. WAL stream handles invalidation ; no TTLs, no stale window, no tuning. the shape of your traffic, not the shape of your schema.
010
PgCache 🐘🦀 @pgcache.bsky.social · 13/05/2026
my postgres read replica bill, itemized: data I actually query ✓ tables from 2022 I forgot exist ✓ deprecated user_sessions table ✓ 6 months of audit logs ✓ cold data that hasn't been touched since the last oncall incident ✓ you replicate all of it. every time. to serve 20% of your reads.
010
PgCache 🐘🦀 @pgcache.bsky.social · 06/05/2026
AWS read replicas are expensive because they copy everything to serve a small fraction of reads. PgCache is a smart read replica that caches only hot data, stays in sync via CDC, and can reduce IOPS by 40–60%. Free trial. Free small instance. Deploy in minutes.
110
PgCache 🐘🦀 @pgcache.bsky.social · 05/05/2026
Stop scaling Postgres with brute force. Read replicas copy 100% of your data for a fraction of queries...and add real ops overhead. PgCache: cache the hot 20% that matters. #PostgreSQL #SRE
231
PgCache 🐘🦀 @pgcache.bsky.social · 30/04/2026
Stop wasting money replicating 100% of your Postgres DB just to serve the hot 20% of your data. 💸 PgCache is a "Pareto Replica" proxy that uses CDC for real-time sync. No stale TTLs, no app rewrites.
110
PgCache 🐘🦀 @pgcache.bsky.social · 29/04/2026
Release notes for PgCache/0.4.9: 0.4.9 - 2026-04-24 Materialized query results Pre-PG18 search_path change tracking Default admission_threshold changed from 2 to 1 New mv_size_ratio setting (default 10)
101
PgCache 🐘🦀 @pgcache.bsky.social · 28/04/2026
Stop paying to replicate cold data. Cache the 20% that drives 80% of your traffic.
000
PgCache 🐘🦀 @pgcache.bsky.social · 24/04/2026
Smart DBAs are ditching read replicas and crazy IOPS bills. DM to learn more. ... or try it for yourself on our AWS AMI (v0.4.8): aws.amazon.com/marketplace/...
000
Reposted by PgCache 🐘🦀
PgDay Boston @pgdayboston.bsky.social · 22/04/2026
We are dedicated to making sure that PgDay Boston is the best it can be, and your company could be a part of that! We have sponsorship opportunities available! Talk to us today! 2026.pgdayboston.org/sponsors/ #PostgreSQL #postgres #conference
2026.pgdayboston.org
PgDay Boston 2026 Sponsors
We are proud to be associated with these fine sponsors, without whom PgDay Boston 2026 would not be possible!
044
Reposted by PgCache 🐘🦀
AI Hacker Jobs @aihackerjobs.bsky.social · 20/04/2026
🚀 Full Stack Software Engineer @ Piq Energy – Remote (US) Shape AI-powered grid simulation! Tech: Python, FastAPI, LLM agents, Postgres, Temporal, AWS, Typescript, Svelte, GraphQL, Mapbox, D3.js Salary: $150k-$250k #FullStack #Remote #EnergyTech #AI #Hiring #Python aihackerjobs.com/company/piqe...
041
PgCache 🐘🦀 @pgcache.bsky.social · 22/04/2026
When you realize you could be getting more out of PostgreSQL with an automated caching proxy
000
PgCache 🐘🦀 @pgcache.bsky.social · 22/04/2026
If you’re scaling cloud Postgres and still adding read replicas… you’re doing it the hard way. PgCache auto-caches ~80% of queries via proxy. No app changes. No invalidation drama (CDC handles it). Some of what we support 👇 Reply "FULL" and I'll send you the full list
list showing some of the query patterns supported by PgCache
110
PgCache 🐘🦀 @pgcache.bsky.social · 20/04/2026
Scaling database teams don’t need more cache complexity. They need a way to shape database load, effortlessly. PgCache = no app changes CDC-fresh cache 80% of common query patterns covered automatically Less babysitting. More control. DM to see if we fit your stack.
110
PgCache 🐘🦀 @pgcache.bsky.social · 17/04/2026
Database stability with zero app changes?! (1/3) PgCache is a wire-compatible, transparent Postgres proxy that caches read data, then keeps it fresh using PostgreSQL Logical Replication Business Value 👇
110
PgCache 🐘🦀 @pgcache.bsky.social · 16/04/2026
Most people think CDC filtering happens after the replication stream leaves Postgres: Grab full logical stream → filter tables in app code → drop noise. ...But it's not!
100
PgCache 🐘🦀 @pgcache.bsky.social · 15/04/2026
“Problematic for read replicas, but perfect for caching.” That’s the best mental model for Postgres logical replication. (1/4)
110
Reposted by PgCache 🐘🦀
postgresconf.bsky.social @postgresconf.bsky.social · 15/04/2026
We’re excited to have Google Cloud supporting Postgres Conference 2026 as our Premier Conference Sponsor. Their work in cloud infrastructure and managed PostgreSQL helps teams run at scale with reliability. Get your tickets: postgresconf.org/conferences/...
011
PgCache 🐘🦀 @pgcache.bsky.social · 14/04/2026
"Our query cache failed with parameterized queries because the fingerprints went wrong.” Heard that last week. It's why we're building PgCache: to support the features that matter in production, like prepared statements and partitions. Looking for 1–2 more teams to pilot (DM me)
001
PgCache 🐘🦀 @pgcache.bsky.social · 09/04/2026
Postgres deserves a better read cache. We're testing PgCache, our Postgres-only cache that acts like a transparent proxy. Drop-in, auto-refresh, dead simple to deploy. If this sounds useful, join the waitlist: pgache.com#waitlist
000