Search Postgresql Archives

Re: How to modify ENUM datatypes?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Robert Treat wrote:

If one were to have built something on postgresql 5 years ago, they would have had to do it on 7.3. Whenever anyone posts a problem on 7.3, the first thing people do now days is jump up and down waving thier arms about while exclaiming how quickly they should upgrade.

[snip]

> I'd have to
> say that the core developers for this project do not release software
> with the expectation that you will use if for more than 5 years.

From what I've seen on the list so far upgrades are advised precisely because somebody has had to ask for help with a problem - one that's usually resolved in newer versions. Doubly so because the issues raised are usually performance related or are caused by limitations in 7.3 (or whatever they're running).

If upgrading solves a problem that somebody is asking for help with, then advising the user to upgrade makes sense.

Consider operating systems. An OS vendor might expect a given version to be used for five years or more, but if you ask them for help because you're encountering awful performance with 2TB disks or high CPU load on 10GigE networks they're quite likely to advise you to upgrade the OS to a version with enhancements that solve your problems.

That says nothing about the people out there still using 7.3 and similar without problems, running well within its capabilities and happy with what it's doing. I doubt many people would advise them to upgrade - at least not in a hurry and not with any jumping and hand-waving.

I often see responses along the lines of "if you're using 8.3 then just do <blah> otherwise you'll need to...." - so there doesn't appear to be any assumption that the first step must be to upgrade to the latest version.

My impression from using PostgreSQL is that people using old versions are taken seriously. Data corruption, crash and security bug fixes get applied to very old versions. For example, 7.3.21 was released on Jan 2008, and includes several fixes:

http://www.postgresql.org/docs/current/static/release-7-3-21.html

Given that 7.3 was released in late 2002:

http://www.postgresql.org/docs/current/static/release-7-3.html

I think that's pretty good myself.

Given that PostgreSQL upgrades aren't trivial, it's important to have these ongoing releases for older versions. It's great to see that need so well met.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux