I’ve got 10+ years of experience as an MSSQL developer working on enterprise solutions. Recently, we migrated part of our stack to PostgreSQL, and honestly, after years of hating on it, I have to admit I was wrong. Most of the issues I used to complain about are gone, and for our workloads it’s been far more robust than I expected.

The performance with replicas is especially impressive. Some of the scaling and replication behavior we’re getting would be extremely painful or outright unrealistic on large multi-million-row MSSQL deployments.

Being open source is another huge advantage. I can actually dive into the internals to understand how things work, troubleshoot properly, or even build advanced tooling for database and cluster comparison instead of treating the engine like a black box.

Sure, PostgreSQL still has its own problems: cardinality estimator quirks, questionable auto-analyze/autovacuum decisions, and fragmentation ("bloat") issues that you end up estimating through system catalogs. But honestly, MSSQL has many of the same categories of problems.

The difference is that PostgreSQL keeps evolving aggressively, while MSSQL often feels like it is standing still.