Re:Why Does Everyone Run Ancient Postgres Versions?
by Tostino on Friday October 18, 2024 @10:58AM
(#41880033)
As someone who has a decade of professional postgres experience (and built my company on it), and 6 years of SqlServer experience, I couldn't agree more with your comment. I really, really like the TDS wire protocol and what it enables.
I also really miss their query optimizer. It was just so damn smart.
Re:Why Does Everyone Run Ancient Postgres Versions?
by chasil on Friday October 18, 2024 @11:05AM
(#41880091)
I've only done it once, but doing an "rpm -Uvh" on the SQL Server binaries in Linux, then starting up the database did an immediate upgrade of the database files.
Oracle's DBUA is so much more painful.
Re:Why Does Everyone Run Ancient Postgres Versions?
by whartung on Friday October 18, 2024 @11:18AM
(#41880212)
I'm sorry, not to quibble about the quality of the TDS protocol, but what does it have to do with the upgradability of SqlServer?
Re:Why Does Everyone Run Ancient Postgres Versions?
by Tostino on Friday October 18, 2024 @11:31AM
(#41880347)
Nothing, they're unrelated.
However, I agree with OP that SQL Server does have a solid upgrade story and it's generally pain free.
They are just two aspects I really wish Postgres could do better on, and I miss working with those parts of SQL Server.
* Upgrades
* Database Protocol
MS SQL Server does better on both of these fronts: Upgrades, when running MS SQL Server in a container, is rebooting the database with the new database engine version. The DBMS sees the old files, upgrades them in place and starts the DB completely seamlessly 100% of the time.
The MS SQL Server protocol, TDS, supports native named parameters, executes the T-SQL PL inline with SQL. TDS also supports inline query cancellations because the protocol is framed, and both T-SQL and TDS supports returning multiple result sets from a single query.
But yes, whenever I see PG docs saying, major versions require an export and re-load, I shudder.