X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DCCA79FA5DD for ; Wed, 31 May 2006 19:04:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 84171-02 for ; Wed, 31 May 2006 19:04:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 1CFE69FA5D3 for ; Wed, 31 May 2006 19:04:04 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 9EB6C31D9B; Thu, 1 Jun 2006 00:04:02 +0200 (MET DST) From: Chris Browne X-Newsgroups: pgsql.general Subject: Re: A quick question on CONTRIB package Date: Wed, 31 May 2006 17:45:01 -0400 Organization: cbbrowne Computing Inc Lines: 49 Message-ID: <604pz5uaw2.fsf@dba2.int.libertyrms.com> References: <1149096921.25526.121.camel@state.g2switchworks.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:IBveyGDbEOjiYVI4W6bZjl8jvVI= To: pgsql-general@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/1568 X-Sequence-Number: 96360 ramakrishna.reddy@indussoft.com ("Ramakrishna Reddy") writes: > Thanks for your vauable suggestions. > > We have very huge databases in many installations and infact have > plans for upgrading to latest releases. But as we are not very sure > about the stability of post 7.2.1 versions, refrained from doing > that. Could you please suggest me which version is the best in terms > of stability, performance and minimal bugs. We want to upgrade this > on both our Windows as well as Linux environments. Well, there are only three versions worth considering: 1. 7.4.13; 7.4 is still being supported, somewhat. It's now an old version, where numerous improvements and some fixes have been applied to later versions that will never be applied to it. As compared to 8.0 and 8.1 releases, there are quite a lot of things *missing* in 7.4 that help the subsequent major versions to provide both better performance and more predictable/stable performance. I would *NOT* recommend that you jump to 7.4; that would merely bring you to having a 2-and-a-half year-old version, lacking the benefits of 8.0 and 8.1. 2. 8.0.8. This is also being supported. It is an old version, as 8.1 was released about six months ago. Again, fixes and *numerous* improvements have been applied to 8.1 that will never be applied to the 8.0 series. 3. 8.1.4. This is the latest release of the latest major version. As "latest major version," it can be expected to have better performance than any earlier major version. There haven't been many reports of bugs that were introduced newly to this major version, so this version seems reasonably stable overally. As the latest release of that major version, it can be expected to be more stable than any previous release of 8.1. Certainly it may be expected to have the fewest bugs of any 8.1.x release. It all seems to point to 8.1.4 being the best candidate. -- output = ("cbbrowne" "@" "ntlug.org") http://www3.sympatico.ca/cbbrowne/linux.html "Lisp is an eternal thought in the mind of God." --Crassus, mutatis mutandi