1 Repo
Specialized routing for queries targeting internal database system catalogs across a sharded cluster.
Distinct from Query Routing: Specifically targets system catalog queries rather than general user-data SQL routing.
Explore 1 awesome GitHub repository matching data & databases · System Catalog Routing. Refine with filters or upvote what's useful.
pgdog is a PostgreSQL sharding proxy, distributed SQL router, and connection pooler. It is designed to enable horizontal data distribution by splitting tables and indices across multiple independent servers to scale storage and processing capacity. The project distinguishes itself through online resharding capabilities, using logical replication to move data between shards without application downtime. It supports multiple routing strategies, including hash, list, and range-based query routing, and manages distributed atomic transactions using a two-phase commit process to ensure consistency
Handles queries to system tables by distributing them across shards to maintain tool compatibility.