627
this post was submitted on 08 May 2025
627 points (99.2% liked)
Technology
69891 readers
2716 users here now
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related news or articles.
- Be excellent to each other!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
- Check for duplicates before posting, duplicates may be removed
- Accounts 7 days and younger will have their posts automatically removed.
Approved Bots
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
There are three real DBMS options for enterprise - Oracle, PGSQL, MSSQL, and Oracle is the most powerful and least problematic of them.
How is it less problematic? I've only ever worked with the other two
Well, compare setting up replication under Oracle and PGSQL.
Replication with postgres is really simple. Combine it with patroni and it's so much better than oracle
Oh, I'm not a DBA, so a stupid question - how do you avoid PGSQL replication breaking on full vacuum of a table? With patroni, shmatroni, macaroni, whatever.