Why open source always wins
Most tools we use on a daily basis are built in the open. The core team works for a company, while a bunch of people from the internet donate their time and effort to a project they like.
PgDog Blog4 min read
PgDog
10 stories
PgDog vs. RDS Proxy
PgDog is a proxy for scaling PostgreSQL. It’s one among many, so we’re starting this series of posts to compare us with the competition.
PgDog Blog5 min readWhy we built yet another Postgres connection pooler
PgDog is a proxy for scaling Postgres. One of its features is connection pooling, which allows many client applications to use the same database without exceeding its connection limit.
PgDog Blog5 min readOur funding announcement
The reason DBs like Mongo or Dynamo exist is because Postgres has a scaling problem. If you could make it just work, with 100 TB+ tables and 1M queries per second, we don’t think you would use anything else.
PgDog Blog2 min readReplacing Protobuf with Rust to go 5 times faster
Forking pg_query.rs to replace Protobuf with bindgen-generated direct C-to-Rust struct mappings, yielding 5x faster query parsing and 10x faster deparsing in PgDog.
PgDog Blog7 min readYou should shard your database
An on-call story about a 300 GB sequential scan, what default_statistics_target really controls, and why tuning autovacuum eventually loses to horizontal sharding.
PgDog Blog7 min readWriting nothing but docs for a week
Lessons from a week of writing PgDog's documentation: validating TOML examples with configcheck, parsing SQL snippets with pglast in CI, and why LLMs can't write the why.
PgDog Blog5 min readPrimary keys in sharded databases
Guaranteeing globally unique BIGSERIAL primary keys across shards using Postgres's satisfies_hash_partition function, with no UUIDs and no external ID generation services.
PgDog Blog6 min readPgDog adds support for Rust plugins
How PgDog exposes parsed SQL ASTs to dynamically loaded Rust plugins via the C ABI, letting you customize sharding and load-balancing logic without serialization overhead.
PgDog Blog6 min readScaling Postgres LISTEN/NOTIFY
Scaling Postgres pub/sub past max_connections by terminating LISTEN/NOTIFY in PgDog, fanning out messages over Tokio broadcast channels, and using Postgres only as the broker.
PgDog Blog6 min read
Showing 10 of 10 stories
You're all caught up.
AiByts Weekly Brief
Get the top AI news and tools straight to your inbox every week.
Weekly · AI news
Join 15,000+ AI enthusiasts