pgdogdev/pgdog v0.1.36 on GitHub

What's Changed

feat: parallelize copy data & schema sync across shards
feat: change default setting value for query_cache_limit to 1000 to avoid heavy memory usage on first deployment
feat: log warning if re-sharding replication is missing rows; this if only impactful is using copy-data without --replication-only flag and shouldn't happen under normal state
feat: add 53-bit unique ID generator for apps that pass IDs directly to JS frontends
feat: add user-friendly interface to create sharded sequences (pgdog.install_sharded_sequence pl/pgsql function)
fix: use correct backend data type for cross-sharded count(*), fixes count(*)::int returning incorrect count
fix: oid is u32, not i32; affected old databases with schema churn (oid exceeded 2.2B)
fix: omnisharded table re-sharding: copy and replication copied the same table N times (N = number original shards)
chore: regression testing for unique id
chore: migrate to RWX for CI by @kylekthompson
chore: resharding integration tests
fix: detect SELECT ... FOR UPDATE inside CTEs
fix: potentially dropping child table rows during streaming replication / re-sharding

Full Changelog: v0.1.35...v0.1.36