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).
[ Parent
| on HN ]
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.