Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 26FC89F964E for ; Tue, 21 Aug 2007 14:29:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 78620-05 for ; Tue, 21 Aug 2007 14:29:48 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.189]) by postgresql.org (Postfix) with ESMTP id E22AF9F9642 for ; Tue, 21 Aug 2007 14:29:47 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id l15so1214115rvb for ; Tue, 21 Aug 2007 10:29:46 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=KgxesfVjES7BmsVOUN3ImcxrEoi8fQIsfyS4rQVNUIl4pASH33nVsHe1ArbKB6zAyzbWQzFElftMeodWaKkrnI1+2uZbV+4+EkQbUB8OWYpdT88FGYwLGpjvbGGWhaFG6yQIkkP6CNW0sGB1gC84oPoFZ+ODh5t0+Li6Y12lleA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=PcvHQz7lAI4U5sOxVhAYcTw+ciBsYC4SMqwvqLRYKniHXvm/ds9kBIqp7SY2AEz1jlhKZ1gVi04VRQDEFjoU8QGxtE9GLZSlubPiWvfBQHZNNVOHWLL8nRu4s9GT6/ZORdJpjcjNYati6KAiYGC5JINKfaXRSWrZ43VcoAU17aE= Received: by 10.140.186.18 with SMTP id j18mr3494776rvf.1187717386804; Tue, 21 Aug 2007 10:29:46 -0700 (PDT) Received: by 10.141.98.12 with HTTP; Tue, 21 Aug 2007 10:29:46 -0700 (PDT) Message-ID: Date: Tue, 21 Aug 2007 12:29:46 -0500 From: "Scott Marlowe" To: "Medi Montaseri" Subject: Re: ROI on 7.2 to 8.2 Cc: pgsql-admin@postgresql.org In-Reply-To: <8078a1730708211016u7f825121s9abc8e015aab53a0@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <8078a1730708211016u7f825121s9abc8e015aab53a0@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/260 X-Sequence-Number: 26591 On 8/21/07, Medi Montaseri wrote: > Hi, > > I have finally convinced my manager to "consider" the idea of migrating from > 7.2 to 8.2. Obviously he needs an ROI (Return Of Investment) analysis (in a > technical sense). > > So, I am wondering if anyone has worked on a similar project where you had > to go thru the release notes and bug fixes to compile such a motivational > speech and willing to share. This one's really pretty simple. 1: 7.2 is no longer supported by the community. any issues, you're pretty much on your own. 2: 7.2 has a problem with transaction ID wraparound that cannot be fixed. You have to dump and reload your data every so often or you will lose data 3: I believe, but I'm not entirely sure, that there are other known breakages in 7.2 that will eat your data eventually. Scour the list for references to such things by Tom Lane.