On 10/20/06, John Sidney-Woollett <johnsw@xxxxxxxxxxxxx> 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
