Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id BE2242E0050 for ; Fri, 2 May 2008 13:13:45 -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 21757-03 for ; Fri, 2 May 2008 13:13:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.emproshunts.com (mail.emproshunts.com [66.64.191.19]) by developer.postgresql.org (Postfix) with ESMTP id 74F202E003E for ; Fri, 2 May 2008 13:13:33 -0300 (ADT) Received: from [192.168.1.49] by mail.emproshunts.com (GMS 15.00.3626/KX5895.00.ca7cb0e7) with ESMTP id zzglhaaa for pgsql-performance@postgresql.org; Fri, 2 May 2008 12:13:31 -0400 Message-ID: <481B4B46.8090107@emproshunts.com> Date: Fri, 02 May 2008 12:11:34 -0500 From: Justin User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: Gauri Kanekar CC: pgsql-performance@postgresql.org Subject: Re: Pros and Cons of 8.3.1 References: <7e4ba9550805020031l6d20b715n8f01cd5e79147dc7@mail.gmail.com> In-Reply-To: <7e4ba9550805020031l6d20b715n8f01cd5e79147dc7@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [192.168.1.49] X-DNSBL: 0 X-AntiSpam: Checked for restricted content by Gordano's AntiSpam Software X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/14 X-Sequence-Number: 29982 Gauri Kanekar wrote: > > Hi, > > Can anyone who have started using 8.3.1 list out the pros and cons. > > Thanx in advance > > ~ Gauri don't know for sure if it is windows to linux but we moved to 8.2 that was install on windows and moved to 8.3.1 on Ubuntu using the compiled version from Ubuntu We had minor annoying problem with implicit data conversion no longer happens Had several pl/pgsql functions called each other where a programmer got lazy to not making sure the variable typed matched the parameter type so we get an error yelling at us can't find function due to data type mismatch . Its was very easy to fix. There is allot changes to how Text searches work and the indexes