PgCat: Next-Gen PostgreSQL Connection Pooler
PgCat is an advanced PostgreSQL pooler and proxy designed to optimize database performance with features like sharding, load balancing, and failover capabilities. Built on an asynchronous multi-threaded runtime, it efficiently manages high query loads while providing robust statistics and flexible configuration options.
Features
Transaction and session pooling with enhanced handling of bad clients
Multi-threaded architecture leveraging Tokio for optimal performance on multicore machines
Automatic load balancing of read queries across primary and replica databases
Dynamic failover capabilities with regular health checks for reliable query routing
Support for SSL/TLS connections to secure client-server communications
Live configuration reloading for seamless updates without downtime
Experimental sharding options including automatic key detection and comment parsing
Mirroring capabilities for testing and data validation across multiple databases