Re:An early look at Postgres 14: Performance and monitoring ...
by eterm on Saturday May 22, 2021 @03:13PM
(#27249460)
I think anyone who has worked a lot with MSSQL would disagree with Postgres being "so much better". It's only really in the last few years that postgres has pulled ahead, MSSQL was lot more feature rich and performant for a decade.
[ Parent
| on HN ]
Re:An early look at Postgres 14: Performance and monitoring ...
by harikb on Saturday May 22, 2021 @03:30PM
(#27249585)
MSSQL ? As in Microsoft SQL Server? I have heard this argument a lot and all the comparisons I have seen are specific benchmarks on specialized hardware. My own personal experience wasn’t anything like the benchmarks
Re:An early look at Postgres 14: Performance and monitoring ...
by HideousKojima on Saturday May 22, 2021 @04:27PM
(#27249984)
MSSQL still has a few features that set it apart from Postgres. Off the top of my head are Filestream (basically storing files in the database while still having them accessible as files on the filesystem) and temporal tables without the need for extensions.
Personally if I were choosing the tech stack for my company I'd still go for Postgres though
Re:An early look at Postgres 14: Performance and monitoring ...
by johnthescott on Monday May 24, 2021 @10:26PM
(#27272013)
pg has had file fw for years: https://www.postgresql.org/docs/13/file-fdw.html