from Hacker News

Show HN: Pgwrh – PostgreSQL read replica sharding

by mkleczek on 2/18/25, 6:04 AM with 0 comments

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.