Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 570092E0057 for ; Fri, 2 May 2008 13:46:39 -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 29871-01 for ; Fri, 2 May 2008 13:46:33 -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 774D02E003B for ; Fri, 2 May 2008 13:46:33 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Fri, 02 May 2008 11:46:32 -0500 Message-Id: <481AFEEB.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.3 Date: Fri, 02 May 2008 11:46:19 -0500 From: "Kevin Grittner" To: "Gauri Kanekar" , Subject: Re: Pros and Cons of 8.3.1 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/17 X-Sequence-Number: 29985 Attempting to resend. My first attempt was rejected with this explanation: Your message to the pgsql-performance list has been denied for the following reason(s): A message was previous posted with this Message-ID Duplicate Message-ID - <481AFC7B.EE98.0025.0@wicourts.gov> (Fri May 2 13:36:52 2008) Duplicate Partial Message Checksum (Fri May 2 13:36:52 2008) >>> 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