X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E9C41D1EE95 for ; Thu, 29 Apr 2004 18:08:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 79425-06 for ; Thu, 29 Apr 2004 18:08:34 -0300 (ADT) Received: from gpdnet.co.uk (gpdnet.plus.com [212.56.100.243]) by svr1.postgresql.org (Postfix) with ESMTP id E9EB7D1EDA0 for ; Thu, 29 Apr 2004 18:08:30 -0300 (ADT) Received: from gary (unverified [192.168.1.2]) by gpdnet.co.uk (SurgeMail 1.8g3) with ESMTP id 243 for ; Thu, 29 Apr 2004 22:08:01 +0100 From: "Gary Doades" To: pgsql-performance@postgresql.org Date: Thu, 29 Apr 2004 22:08:28 +0100 MIME-Version: 1.0 Subject: Re: planner/optimizer question Message-ID: <40917CDC.3078.14EE7897@localhost> In-reply-to: <20040429203519.GI26634@it.is.rice.edu> References: <409172FA.1509.14C7E00E@localhost> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Server: High Performance Mail Server - http://surgemail.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/504 X-Sequence-Number: 6804 On 29 Apr 2004 at 15:35, Kenneth Marshall wrote: > Did you try to cluster based on the index? > > --Ken Yes, This speeds up the index scan a little (12%). This to me just reinforces the overhead that subsequently having to go and fetch the data tuple actually has on the performance. Cheers, Gary.