Chris --
You asked
I'm currently using 7.4 and I trying find out what the value/advantage
of upgrading to a more recent version and to which version.
Eventually 7.4 will not be supported (there's discussion elsewhere on how to
deal with 7.3), so it would pay to move off of it well before that time
(admittedly a year or more off, at a guess).
As another poster pointed out, the release notes indicate improvements that
have been made, some of which are not ported back to earlier releases. These
include stability improvements, often speed improvements (depending on your
useage) and new features or better integration of existing ones (autovacuum
seems much better in 8.2 than 8.1, and 8.3 seems even better; the integration
of tsearch2 into the core in 8.3; easier quoting in stored procedures, etc.).
The jump from 7.4.x to 8.x is proving a challenge for us since we have one set
of databases still on 7.4.14 (whatever the latest and greatest point release
is); they will benefit from the upgrade, but the old databases accepted some
bad UTF characters and the newer postgreses (postgresii ?) are stricter about
bad data and reject them, so there's some clean up involved. Other than that
upgrades have been relatively painless (7.4 -- 8.1.x -- 8.2 now).
HTH,
Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company
Confidentiality Notice: This e-mail message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information and must be protected in accordance with those
provisions. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
(My corporate masters made me say this.)