Hasty Briefsbeta

Bilingual

PgDog is a transaction pooler logical replication manager can shard PostgreSQL

a year ago
  • #Rust
  • #PostgreSQL
  • #Database Sharding
  • PgDog is a transaction pooler and logical replication manager for PostgreSQL, written in Rust.
  • It supports sharding, managing hundreds of databases and thousands of connections.
  • Quick installation options include Helm charts and Docker Compose.
  • Features include load balancing, health checks, and failover mechanisms.
  • PgDog can route queries to shards automatically and supports cross-shard queries.
  • It includes a CSV parser for splitting COPY commands across shards.
  • Logical replication allows sharding existing databases without downtime.
  • Configuration is flexible with runtime adjustments possible.
  • PgDog is open-source under AGPL v3, allowing internal use and private modifications.
  • Early adopters are encouraged to try PgDog, with regular updates on feature stability.