!postgresql
@lemmy.worldUsual story - joined a startup and their production database is a single instance RDS running 11.3.
We can't upgrade or scale or even change configuration without taking the database offline. We want to move everything to an Aurora Postgres compatible cluster that can scale horizontally.
What options do we have? I've used Bucardo in the past to do one-way sync, but how is it at multi-master replication? What would you use for this task?
Are/were you a moderator at /r/PostgreSQL? Send proof, and I will hand over the keys.
https://www.enterprisedb.com/blog/highlights-postgresql-16-beta-release
The PostgreSQL Global Development Group released PostgreSQL 16 Beta 1 on May 25, 2023. PostgreSQL 16 improves logical replication by enabling replication from standbys as well as the ability to apply large transactions in parallel for improved performance. This blog covers the highlights of this release.
https://www.citusdata.com/blog/2023/05/05/whats-new-in-citus-11-3-multi-tenant-saas/
All about what’s new in the Citus 11.3 extension to Postgres, with new tenant monitoring features for SaaS workloads, metadata synchronization for those with large numbers of tables, parallel shard rebalancing, MERGE support for co-located distributed tables, and logical decoding for CDC (in preview.)
https://www.depesz.com/2023/02/27/waiting-for-postgresql-16-add-pg_stat_io-view-providing-more-detailed-io-statistics/
https://www.percona.com/blog/should-postgresql-become-multi-threaded/
Is it time to make PostgreSQL multi-threaded? Peter Zaitsev weighs in.