Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 60728632CCC for ; Wed, 10 Feb 2010 04:49:31 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 98442-02 for ; Wed, 10 Feb 2010 08:49:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from out-0.mx.aerioconnect.net (out-0-38.mx.aerioconnect.net [216.240.47.98]) by mail.postgresql.org (Postfix) with ESMTP id 96EFC632FDA for ; Wed, 10 Feb 2010 04:49:20 -0400 (AST) Received: from idiom.com (mx0.idiom.com [216.240.32.160]) by out-0.mx.aerioconnect.net (8.13.8/8.13.8) with ESMTP id o1A8nHoU004493 for ; Wed, 10 Feb 2010 00:49:17 -0800 X-Client-Authorized: MaGic Cook1e Received: from [192.168.2.113] (adsl-71-135-173-32.dsl.pltn13.pacbell.net [71.135.173.32]) by idiom.com (Postfix) with ESMTP id 5705E2D6011 for ; Wed, 10 Feb 2010 00:29:54 -0800 (PST) Message-ID: <4B726E81.2060904@obviously.com> Date: Wed, 10 Feb 2010 00:29:53 -0800 From: Bryce Nesbitt User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090410 SUSE/1.1.18-0.1 SeaMonkey/1.1.18 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? References: <4B723042.7090406@obviously.com> In-Reply-To: <4B723042.7090406@obviously.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.67 on 216.240.47.51 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.59 tagged_above=-10 required=5 tests=AWL=-0.591, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201002/153 X-Sequence-Number: 37574 Or, if you want to actually read that query plan, try: http://explain.depesz.com/s/qYq