Go ahead, self-host Postgres

Re:Go ahead, self-host Postgres by franckpachot on Saturday December 20, 2025 @12:10PM (#46337664)

Beyond the hype, the PostgreSQL community is aware of the lack of "batteries-included" HA. This discussion on the idea of a Built-in Raft replication mentions MongoDB as:

>> "God Send". Everything just worked. Replication was as reliable as one could imagine. It outlives several hardware incidents without manual intervention. It allowed cluster maintenance (software and hardware upgrades) without application downtime. I really dream PostgreSQL will be as reliable as MongoDB without need of external services.

https://www.postgresql.org/message-id/0e01fb4d-f8ea-4ca9-8c9...

[ Parent | on HN ]

Re:Go ahead, self-host Postgres by abrookewood on Saturday December 20, 2025 @04:28PM (#46339794)

"I really dream PostgreSQL will be as reliable as MongoDB" ... someone needs to go and read up on Mongo's history!

Sure, the PostrgreSQL HA story isn't what we all want it to be, but the reliability is exceptional.

[ Parent | on HN ]

Re:Go ahead, self-host Postgres by computerfan494 on Saturday December 20, 2025 @04:45PM (#46339924)

Postgres violated serializability on a single node for a considerable amount of time [1] and used fsync incorrectly for 20 years [2]. I personally witnessed lost data on Postgres because of the fsync issue.

Database engineering is very hard. MongoDB has had both poor defaults as well as bugs in the past. It will certainly have durability bugs in the future, just like Postgres and all other serious databases. I'm not sure that Postgres' durability stacks up especially well with modern MongoDB.

[1] https://jepsen.io/analyses/postgresql-12.3

[2] https://archive.fosdem.org/2019/schedule/event/postgresql_fs...

[ Parent | on HN ]

Re:Go ahead, self-host Postgres by abrookewood on Sunday December 21, 2025 @06:53AM (#46344160)

Thanks for adding that - I wasn't aware.

[ Parent | on HN ]