X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F2CB0D815A for ; Fri, 14 Oct 2005 04:40:29 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82162-03 for ; Fri, 14 Oct 2005 07:40:27 +0000 (GMT) Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by svr1.postgresql.org (Postfix) with ESMTP id 1AA38D7FEA for ; Fri, 14 Oct 2005 04:40:28 -0300 (ADT) Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 278B04142AF; Fri, 14 Oct 2005 08:40:25 +0100 (BST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id DDFBF15ED9; Fri, 14 Oct 2005 08:38:41 +0100 (BST) Received: from mainbox.archonet.com ([127.0.0.1]) by localhost (mainbox [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22826-05; Fri, 14 Oct 2005 08:38:39 +0100 (BST) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 5D30715ED5; Fri, 14 Oct 2005 08:38:39 +0100 (BST) Message-ID: <434F607F.8080100@archonet.com> Date: Fri, 14 Oct 2005 08:38:39 +0100 From: Richard Huxton User-Agent: Thunderbird 1.4.1 (X11/20051006) MIME-Version: 1.0 To: Nörder-Tuitje@archonet.com, Marcus Cc: pgsql-performance@postgresql.org Subject: Re: Optimizer misconfigured ? References: <16F953410A0F1346848DCB476A989CFE34B4@swtexchange2.technology.de> In-Reply-To: <16F953410A0F1346848DCB476A989CFE34B4@swtexchange2.technology.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Amavis-Alert: BAD HEADER Non-encoded 8-bit data (char C3 hex) in message header 'To': To: N\303\266rder-Tuitje@ar... X-Spam-Status: No, hits=0.059 required=5 tests=[AWL=0.009, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/233 X-Sequence-Number: 15001 N=F6rder-Tuitje wrote: > Hi, >=20 > meanwhile I have received the hint to make postgres use the index via >=20 >=20 > SET ENABLE_SEQSCAN=3DFALSE; >=20 > which fits perfectly. The execution plan now indicates full use of > index. What execution plan? I still only see one message on the list. > Nevertheless this is merely a workaround. Maybe the io-costs are > configured to cheap. Possibly - the explain analyse will show you. -- Richard Huxton Archonet Ltd