Re: Upgrade 7.4 to 8.1 or 8.2?

On 10/20/06, John Sidney-Woollett <johnsw@wardbrook.com> wrote:
> We're looking to upgrade from 7.4 - should we go to 8.1.5 or 8.2?
>
> We have two databases; 7.4.6 and 7.4.11 in a master slave config using
> Slony. Both databases use the C locale with UTF-8 encoding on unix.
>
> We've dumped and loaded the data into an 8.1.4 database and have seen no
> problems with invalid UTF-8 sequences. So we're fairly happy that we can
> upgrade to 8.1.5 pretty easily using Slony.
>
> We're really looking for some extra performance right now.
>
> Are the differences between 8.1.5 and 8.2 significant? Is 8.2 more about
> speed or new features?

I've been developing against 8.2 for months without a single 8.2
specific problem. I run both linux and windows in high load
environments (not so much windows these days tho).  I'm going to go
against the grain here and say go for it: yes, it is faster.  It's up
to you to determine a test period long enough to build up a trust
level.

possible downsides:
* catalog changes during beta period. (dump/reload to update to 8.2
proper, etc).
* last minute feature change.  note recent small change in insert
returning as an example.
* risk of undiscovered bug

ideally, i'd develop/test vs. 8.2 beta, and switch production system
at 8.2 release.

merlin