PgDog features

PgDog contains multiple foundational and unique features which make it a great choice for modern PostgreSQL deployments.

Most features are configurable and can be toggled and tuned. Experimental features are marked as such, and users are advised to test them before deploying to production. Most foundational features like load balancing, healthchecks, and query routing have been battle-tested and work well in production.

Summary

Short summary of currently implemented features.

Feature	Description
Load balancer	Distribute SELECT queries evenly between replicas. Separate reads from writes with a single endpoint.
Health checks	Check databases are up and running, and can serve queries.
Transaction mode	Share PostgreSQL connections between thousands of clients, a necessary feature for production deployments.
Hot reload	Update configuration at runtime without restarting PgDog.
Sharding	Automatic query routing and logical replication between data nodes to scale PostgreSQL horizontally.
Prepared statements	Support for Postgres named prepared statements.
Plugins	Pluggable libraries to add functionality to PgDog at runtime.
Authentication	Support for various PostgreSQL authentication mechanisms, like SCRAM.
Session mode	Compatibility mode with direct PostgreSQL connections.
Metrics	Real time reporting, including Prometheus/OpenMetrics and admin database.

OS support

PgDog doesn't use any OS-specific features and should run on all systems supported by the Rust compiler, e.g. Linux (x86 and ARM64), Mac OS, and Windows.