News for hackers. Stuff that matters.
Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by mastax on Wednesday April 09, 2025 @02:03AM (#43629315)
MySQL logical replication isn’t quite foolproof but it’s vastly easier than anything PostgreSQL offers out of the box. (I hope I’m wrong!)
Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by sgarland on Wednesday April 09, 2025 @08:02AM (#43631153)
I think they’re about the same in complexity, other than that Postgres offers more options. MySQL did have logical replication long before Postgres, so I’ll give it that.

Postgres has one option for replication that is a godsend, though: copy_data. This lets you stand up a new replica without having to first do a dump / restore (assuming your tables are small enough / your disk is large enough, since the primary will be holding WAL during the initial sync). Tbf, MySQL doesn’t need that as much, because it offers parallel dump and restore, even on a single table.