Pgwrh – PostgreSQL read replica sharding
Pgwrh – PostgreSQL read replica sharding
I'd like to present something I've been working on for some time: An extension implementing sharding for PostgreSQL based on logical replication and postgres_fdw. The goal is to scale read queries overcoming main limitation of traditional setups based on streaming replication and hot standbys: lack of sharding and large storage requirements.
Share cardActual performance
Launch Intel predictions
Analyze your own launch →Incorrect prediction on native model
Similar products
Kafka FDW for PostgreSQL
es2postgres – ElasticSearch to PostgreSQL Loader
Metagration: PostgreSQL Migrator in PostgreSQL
PRQL in PostgreSQL
Pg_road – PostgreSQL Table Access Method for Read-Only Archived Data
PGLite – PostgreSQL in the Browser
Kallax a PostgreSQL Typesafe ORM for the Go Language
SSO for PostgreSQL Using OAuth2/OIDC
Play Battleships on PostgreSQL
Interactive PostgreSQL Tutorial