Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 9BEE52E0037 for ; Fri, 2 May 2008 13:36:51 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 25759-03 for ; Fri, 2 May 2008 13:36:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by developer.postgresql.org (Postfix) with ESMTP id B6CB12E002D for ; Fri, 2 May 2008 13:36:17 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Fri, 02 May 2008 11:36:10 -0500 Message-Id: <481AFC7B.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.3 Date: Fri, 02 May 2008 11:35:54 -0500 From: "Kevin Grittner" To: "Gauri Kanekar" , Subject: Re: Pros and Cons of 8.3.1 References: <7e4ba9550805020031l6d20b715n8f01cd5e79147dc7@mail.gmail.com> In-Reply-To: <7e4ba9550805020031l6d20b715n8f01cd5e79147dc7@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/16 X-Sequence-Number: 29984 >>> On Fri, May 2, 2008 at 2:31 AM, in message <7e4ba9550805020031l6d20b715n8f01cd5e79147dc7@mail.gmail.com>, "Gauri Kanekar" wrote: > Can anyone who have started using 8.3.1 list out the pros and cons. There are bugs in the 8.3.1 release which bit us when we started using it; however, these are fixed in the 8.3 stable branch of cvs. We are running successfully with that. These fixes will be in 8.3.2 when it is released. http://archives.postgresql.org/pgsql-bugs/2008-04/msg00168.php It's generally a good idea to test with a new release before putting it into production, especially a major release. Since you asked on the performance list -- we have found performance to be significantly better under 8.3 than earlier releases. Also, the data takes less space on the disk, and checkpoint disk activity spikes are reduced in 8.3. -Kevin