Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id A733F9F95EA for ; Tue, 21 Aug 2007 14:25:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 43362-07 for ; Tue, 21 Aug 2007 14:25:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id AB7A09F978D for ; Tue, 21 Aug 2007 14:25:19 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l7LHPQBh003199 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 21 Aug 2007 10:25:26 -0700 Message-ID: <46CB2001.6090703@commandprompt.com> Date: Tue, 21 Aug 2007 10:25:21 -0700 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5.0.12 (X11/20070604) MIME-Version: 1.0 To: Medi Montaseri CC: pgsql-admin@postgresql.org Subject: Re: ROI on 7.2 to 8.2 References: <8078a1730708211016u7f825121s9abc8e015aab53a0@mail.gmail.com> In-Reply-To: <8078a1730708211016u7f825121s9abc8e015aab53a0@mail.gmail.com> X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.91.1/4018/Tue Aug 21 03:42:09 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Tue, 21 Aug 2007 10:25:26 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/259 X-Sequence-Number: 26590 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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. > > Otherwise, as many links you can provide would be nice. Wow... Does your manager still run Windows 98? Not to be sarcastic but that is essentially what the argument boils down to. 1. 7.2 is *not* supported 2. 7.2 will not receive any backpatches * There are data loss and security bugs that have not been back patched 3. If you post here with a question about 7.2, the first thing you will get back is, "upgrade". 4. 8.2 is much faster (not like 10%, like 100%) Now what problems are you going to run into? Several datatypes in 7.2 are allowed to be '', in 8.x they are not. Specifically number based types. You may have to turn "on" add_missing_from_clause Sincerely, Joshua D. Drake > > Cheers > Medi > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGyyABATb/zqfZUUQRAk0SAJ9kQ2LvZ9MoCVwZX7gHgSB8NNgxygCfYp5a bxD4582Zw+WM2XCEy38idCM= =dP3b -----END PGP SIGNATURE-----