PgCache 🐘🦀 @pgcache.bsky.social · 25/09/2026Which 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/2026Still 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/2026Already 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 000
PgCache 🐘🦀 @pgcache.bsky.social · 16/09/2026We 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/2026Don'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/2026You 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/2026We 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/2026Hulunlante 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.toHow I Put PgCache in Front of a 16-Million-Row Postgres DatabaseReal 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/2026Independent 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.toHow I Put PgCache in Front of a 16-Million-Row Postgres DatabaseReal 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/2026In 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.comGitHub - PgCache/pgcache-benchContribute 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.comGitHub - PgCache/pgcache-benchContribute to PgCache/pgcache-bench development by creating an account on GitHub. 000
PgCache 🐘🦀 @pgcache.bsky.social · 19/08/2026our 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.comLogical replication is for more than just ETL: building PgCache, Wed, Aug 19, 2026, 12:00 PM | MeetupThis 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/2026Some 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.comPgCache - Smart Read Replica for PostgreSQLPgCache 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/2026When 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.comLogical replication is for more than just ETL: building PgCache, Wed, Aug 19, 2026, 12:00 PM | MeetupThis 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/2026The 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.comLogical replication is for more than just ETL: building PgCache, Wed, Aug 19, 2026, 12:00 PM | MeetupThis 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/20262 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/2026Our 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.ukKate, Cloud DBA: Expert Insights on Cloud Database SolutionsExpert Cloud DBA delivering insights on AWS, GCP, RDS & Cloud SQL for seamless cloud database management solutions. 000
PgCache 🐘🦀 @pgcache.bsky.social · 28/07/2026PgCache 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.comThe Postgres Dividend, or How Being Postgres-First Solves Most Hard Cache ProblemsWe 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.comPostgres' Logical Replication Stream Gets A Second Life As A Cache Invalidation EngineTwo 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/2026Caching 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/2026The 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/2026We 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/2026Most 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/2026PgCache 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/pgcachegithub.comGitHub - 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/2026PgCache 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/2026James 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/2026no 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/2026a 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/2026my 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/2026AWS 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/2026Stop 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/2026Stop 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/2026Release 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/2026Stop paying to replicate cold data. Cache the 20% that drives 80% of your traffic. 000
PgCache 🐘🦀 @pgcache.bsky.social · 24/04/2026Smart 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/2026We 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 #conference2026.pgdayboston.orgPgDay Boston 2026 SponsorsWe 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/2026When you realize you could be getting more out of PostgreSQL with an automated caching proxy 000
PgCache 🐘🦀 @pgcache.bsky.social · 22/04/2026If 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 110
PgCache 🐘🦀 @pgcache.bsky.social · 20/04/2026Scaling 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/2026Database 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/2026Most 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/2026We’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/2026Postgres 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