X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5ECD99DC837 for ; Thu, 16 Mar 2006 17:43:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24580-03 for ; Thu, 16 Mar 2006 17:44:00 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 587329DC828 for ; Thu, 16 Mar 2006 17:43:57 -0400 (AST) Received: from crestone.coronasolutions.com (crestone.coronasolutions.com [66.45.104.24]) by svr4.postgresql.org (Postfix) with ESMTP id E46B65AF904 for ; Thu, 16 Mar 2006 21:43:59 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by crestone.coronasolutions.com (Postfix) with ESMTP id ACE8A644365 for ; Thu, 16 Mar 2006 14:43:58 -0700 (MST) Received: from crestone.coronasolutions.com ([127.0.0.1]) by localhost (crestone.coronasolutions.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23674-03 for ; Thu, 16 Mar 2006 14:43:56 -0700 (MST) Received: from [192.168.1.100] (c-67-165-220-189.hsd1.co.comcast.net [67.165.220.189]) by crestone.coronasolutions.com (Postfix) with ESMTP id B584D64425B for ; Thu, 16 Mar 2006 14:43:56 -0700 (MST) Message-ID: <4419DC1C.9070806@drivefaster.net> Date: Thu, 16 Mar 2006 14:43:56 -0700 From: Dan Harris User-Agent: Thunderbird 1.5 (Macintosh/20060122) MIME-Version: 1.0 To: PostgreSQL Performance Subject: Re: Help optimizing a slow index scan References: <4419DB50.10404@drivefaster.net> In-Reply-To: <4419DB50.10404@drivefaster.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at drivefaster.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/259 X-Sequence-Number: 17696 Dan Harris wrote: > explain analyze .... doh.. sorry to reply to my own post. But I messed up copying some of the fields into the select statement that you'll see in the "Sort Key" section of the analyze results. The mistake was mine. Everything else is "normal" between the query and the plan. -Dan