Why Does Everyone Run Ancient Postgres Versions?

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.

[ Parent | on HN ]

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.

[ Parent | on HN ]

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?

[ Parent | on HN ]

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.

[ Parent | on HN ]