3 ms·
Stupid question but does this shard the database as well or do we shard manually and then setup the configuration accordingly ?
by codegeek 7mo ago
Stupid question but does this shard the database as well or do we shard manually and then setup the configuration accordingly ?
- levkk 7mo agoIt shards it as well. We handle schema sync, moving table data (in parallel), setting up logical replication, and application traffic cutover. The zero-downtime resharding is currently WIP, working on the PR as we speak: https://github.com/pgdogdev/pgdog/pull/784 https://github.com/pgdogdev/pgdog/pull/784.
- codegeek 7mo agoIncredible. I am really interested in trying pgdog for our B2B SAAS product. Will do some testing.
- oulipo2 7mo agoInteresting, I'm a bit new to this... could you explain how PgDog works high-level? It's both a connection pooler and a sharding engine? Is there a kind of tutorial to "play" with those features and get a sense of how they work/what complexity they add?
- levkk 7mo agoYeah! Take a look at our Docker demo in GitHub: https://github.com/pgdogdev/pgdog https://github.com/pgdogdev/pgdog