Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 7710E1337BEF for ; Thu, 5 May 2011 17:01:24 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 32314-06 for ; Thu, 5 May 2011 20:01:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from tempest.mainecoon.com (tempest.mainecoon.com [69.12.217.123]) by mail.postgresql.org (Postfix) with ESMTP id E60F81337BD8 for ; Thu, 5 May 2011 17:01:06 -0300 (ADT) Received: from [10.1.1.2] (fw.boscorama.com [75.101.8.88]) by tempest.mainecoon.com (Postfix) with ESMTPSA id 363DB6EA092; Thu, 5 May 2011 13:01:06 -0700 (PDT) Message-ID: <4DC30201.5040009@boscorama.com> Date: Thu, 05 May 2011 13:01:05 -0700 From: Bosco Rama User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.1.19) Gecko/20110420 SeaMonkey/2.0.14 Like Firefox/3.6 MIME-Version: 1.0 To: Brian Connolly CC: pgsql-performance@postgresql.org Subject: Re: Poor query plan chosen in 9.0.3 vs 8.3.7 References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201105/67 X-Sequence-Number: 43576 Hey Brian, Brian Connolly wrote: > (I had to send a follow up email due the length of email restrictions on the > mailing list.) A tip for when you have this problem in the future -- turn off html mail. It will reduce your email message length by 50% - 90%. HTH Bosco.