Live data from Hacker News

Why does everyone run ancient Postgres versions?

neon.tech

451–452 of 452 posts

Re: Why does everyone run ancient Postgres versions?

#451

Upgrades are hard. There was no replication in the before times. The original block-level replication didn't work among different major versions. Slony was a painful workaround based on triggers that amplified writes. Newer PostgreSQL versions are better. Yet still not quite as robust or easy as MySQL. At a certain scale even MySQL upgrades can be painful. At least when you cannot spare more than a few minutes of dow…

"Not as robust as MySQL"? Surely you're joking.

It is funny reading the replies here.

I am a database specialist and have worn the DBA had for many years. I have run MySQL and Postgres in production, both self-hosted and using managed services. Postgres wins on every single dimension that matters, every time. Yes MySQL is easier to setup for non-experts. That counts for nothing.

If you are sticking up for MySQL in this thread... I just don't even know, man.

Re: Why does everyone run ancient Postgres versions?

#452
post #68
post #66

Earlier quoted context omitted.

Why? If the implemented featureset meets your needs, and there are no unresolved bugs or security vulnerabilities relevant to your use cases, what further "maintenance" do you need?

When a critical security patch comes out, you don't want to have to to do a major version upgrade to get it.

[deleted]
Post reply on HN