Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 6F6709F9681 for ; Tue, 21 Aug 2007 14:42:26 -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 90342-08 for ; Tue, 21 Aug 2007 14:42:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.176]) by postgresql.org (Postfix) with ESMTP id 76E6A9F97B2 for ; Tue, 21 Aug 2007 14:42:21 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id u77so3224201pyb for ; Tue, 21 Aug 2007 10:42:20 -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:references; b=p8LNxaw2Wr6Xiwazr/8KHScn41STsdddRCi/3Whn7wlPdeCgB2qTuUFEf7U4NXt6r3DSfi06Q9Ll5oVYMdQHuxLjgkWsEMSvV5fXr70+KzLfe9bn74DbACCGhWIGZKSRha3YRUt6Dxa3iMXoVi2l5aUkDJUAbwlc5DxU/nZ+Pbs= 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:references; b=AhGTmK73EQWpqFS6/BOGbpnxqHwYwIiqCnY3bJDO29+/3LDcIHbxp5/hwyekaTC6cSG25cQF/UBHIvoHNcZ5Mcxy8GP02mbFm/rCY9o4krfjMmO8rlkcrS2Cyrxuqs8iQI0QUd73fAPORbLz80NRpvv793SLd8ueO0QYNNOhq4M= Received: by 10.114.126.1 with SMTP id y1mr1040081wac.1187718139223; Tue, 21 Aug 2007 10:42:19 -0700 (PDT) Received: by 10.65.110.15 with HTTP; Tue, 21 Aug 2007 10:42:19 -0700 (PDT) Message-ID: <8078a1730708211042o5b6442ar315bf0c76bec034a@mail.gmail.com> Date: Tue, 21 Aug 2007 10:42:19 -0700 From: "Medi Montaseri" To: "Joshua D. Drake" Subject: Re: ROI on 7.2 to 8.2 Cc: pgsql-admin@postgresql.org In-Reply-To: <46CB2001.6090703@commandprompt.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_133066_19374853.1187718139127" References: <8078a1730708211016u7f825121s9abc8e015aab53a0@mail.gmail.com> <46CB2001.6090703@commandprompt.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/261 X-Sequence-Number: 26592 ------=_Part_133066_19374853.1187718139127 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline What can I say....at least he is willing to listen now...thanks guys... This is an excellent start... Cheers everyone Medi On 8/21/07, Joshua D. Drake wrote: > > -----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----- > ------=_Part_133066_19374853.1187718139127 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline What can I say....at least he is willing to listen now...thanks guys...
This is an excellent start...

Cheers everyone
Medi

On 8/21/07, Joshua D. Drake <jd@commandprompt.com> wrote:
-----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-----

------=_Part_133066_19374853.1187718139127--