News for hackers. Stuff that matters.
Re:Improving Postgres Connection Scalability: Snapshots by baq on Tuesday October 27, 2020 @06:39AM (#24906090)
what is declining in MSSQL? last 3 years were an absolute gamechanger for my use cases: dockerized linux option for linux testing, very helpful columnstore improvements, the HA story is quite impressive, in fact there are only two major drawbacks that i can tell: no command line tool like pg_dump and the awe-inspiring price of the license (though i hear still less than oracle).
Re:Improving Postgres Connection Scalability: Snapshots by throwaway_pdp09 on Tuesday October 27, 2020 @12:45PM (#24909174)
start here https://www.mssqltips.com/sqlservertip/3074/use-caution-with... Many are fixed but should never have been there. Some are still extant.

There's plenty more low grade shit in what was once a goof product.

I haven't used the features you discuss but then I need basic functionality to work. I've run into stupid performance bugs with trivial CTEs, and I found a link showing a CTE error which I could duplicate (pgres got it right, mssql didn't). Can't find link, sorry.

Re:Improving Postgres Connection Scalability: Snapshots by davidgl on Wednesday October 28, 2020 @01:22PM (#24921494)
The cost, god the cost has got so much higher. I love SQL Server but am being forced off it, especially as you need enterprise to do queryable replicas etc.