Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 10DB39FC3B3 for ; Fri, 18 May 2007 12:41:24 -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 41962-03 for ; Fri, 18 May 2007 12:41:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.livius.net (mail.livius.net [80.86.96.82]) by postgresql.org (Postfix) with ESMTP id 842529FC3A8 for ; Fri, 18 May 2007 12:41:20 -0300 (ADT) Received: from ilgvaio (86-120-229-138.rdsnet.ro [86.120.229.138] (may be forged)) (authenticated bits=0) by mail.livius.net (8.12.5/8.12.5) with ESMTP id l4IFfIeF012366 for ; Fri, 18 May 2007 18:41:18 +0300 From: "Liviu Ionescu" To: Subject: Re: performance drop on 8.2.4, reverting to 8.1.4 Date: Fri, 18 May 2007 18:40:31 +0300 Message-ID: <00a101c79962$de653d50$653e10ac@ilgvaio> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6822 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Thread-Index: AceZPnVmzuN8eh0iSKy5pUZyV78lJgAAopaQAAdTftAAAM914A== In-Reply-To: <8C5B026B51B6854CBE88121DBF097A86C39661@ehost010-33.exch010.intermedia.net> Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/323 X-Sequence-Number: 24713 > under some alignments of the planets 8.1 has similar problems. 8.1 might have similar problems, but the point here is different: if what was manually tuned to work in 8.1 confuses the 8.2 planner and performance drops so much (from 2303 to 231929 ms in my case) upgrading a production machine to 8.2 is a risky business. I probably have hundreds of sql statements in my application, some of them quite complex, and it is not reasonable to check all of them in order to certify them to be 8.2 compliant. regards, Liviu