PgDog
Infrastructure
database proxy and sharding
SHOW HN2026
How HN took it
10 positive, 20 neutral or asking, 0 mixed, 2 critical, out of 32 comments about the project. Thread score +0.26.
Idea: 3 for, 0 againstPerformance: 0 for, 1 againstExecution: 0 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Useful connection pooler and sharding progress
From 3 comments
Great progress, guys! It’s impressive to see all the enhancements - more types, more aggregate functions, cross-node DML, resharding, and reliability-focused connection pooling…
saisrirampur on HNHappy pgdog user here, I can recommend it from a user perspective as a connection pooler to anyone checking this out (we're also running tests and positive about sharding, but…
mijoharas on HNI've been watching PgDog for a while now. Great progress!
jacobsenscott on HN
Connection draining handles connection storms well
From 1 comment
the connection draining feature is really clever. weve dealt with connection storms from app crashes before and the standard playbook is just to restart everything and hope the…
umairnadeem123 on HN
Objections
Cross-shard queries still incomplete and may return incorrect results
From 2 comments
- The maker's post
Congrats on the progress! What is the behavior of PgDoc if it receives some sort of query it can't currently handle properly? Is there a linter/static analysis tool I can use to…
farsa on HN
Two-phase commit lacks crash protection
From 1 comment
It feels better now, but we still need to add crash protection - in case PgDog itself crashes, we need to restore in-progress 2pc transaction records from a durable medium. We…
levkk on HN
Requests
Retry failed queries on another backend
From 1 comment
Some HTTP proxies can do retries -- if a connection to one backend fails, it is retried on a different backend. Can PgDog (or PgBouncer, or any other tool) do something similar…
cuu508 on HN
Read-after-write routing to primary
From 1 comment
The read-after-write problem on replicas is what actually hurts in production. Write goes to primary, next request hits a replica that's a few hundred milliseconds behind, and…
mickelsamuel on HN
Questions
Does it support PostGIS and extensions
From 1 comment
Does it support extensions like PostGIS?
febed on HN
Can it be used with TimescaleDB
From 1 comment
Sorry if this is a weird question, but can I use this with TimescaleDB?
yilugurlu on HN
Alternatives named
PgBouncer
From 2 comments
Some HTTP proxies can do retries -- if a connection to one backend fails, it is retried on a different backend. Can PgDog (or PgBouncer, or any other tool) do something similar…
cuu508 on HNThe read-after-write problem on replicas is what actually hurts in production. Write goes to primary, next request hits a replica that's a few hundred milliseconds behind, and…
mickelsamuel on HN
PgPool-II
From 1 comment
(apologies for new account - NDA applies to the specifics) Nice surprise to see this here today. I was working on a deployment just last week. Unfortunately for me, I found that…
array_loader on HN
Citus
From 1 comment
Great progress, guys! It’s impressive to see all the enhancements - more types, more aggregate functions, cross-node DML, resharding, and reliability-focused connection pooling…
saisrirampur on HN
PostgREST
From 1 comment
How would this product compare to a PostgREST based approach (this is the cool tech behind the original supabase) with load balancing at the HTTP level?
ijustlovemath on HN
HAProxy
From 1 comment