From what I've seen 8.2 is going to offer several nice new features, but I would move to 8.1.5 for now.
Honestly, I would probably wait until 8.2.1 is available before moving to that subversion. No offense against the PG team, but I've been burned by zeroes once too many times to go live with 8.2.0. -- Brandon Aiken CS/IT Systems Engineer -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Sidney-Woollett Sent: Friday, October 20, 2006 11:10 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Upgrade 7.4 to 8.1 or 8.2? 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? John ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
