X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8C6BE9FB1D7 for ; Wed, 23 Aug 2006 23:43:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 10531-07 for ; Wed, 23 Aug 2006 23:43:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 188CD9FA3D7 for ; Wed, 23 Aug 2006 23:43:01 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from m21.unixathome.org (m21.unixathome.org [205.150.199.217]) by svr4.postgresql.org (Postfix) with ESMTP id 1CD245AF89D for ; Thu, 24 Aug 2006 02:42:59 +0000 (GMT) Received: from localhost (localhost [205.150.199.217]) by m21.unixathome.org (Postfix) with ESMTP id E5FCCC383; Wed, 23 Aug 2006 22:43:06 -0400 (EDT) Received: from m21.unixathome.org ([205.150.199.217]) by localhost (m21.unixathome.org [205.150.199.217]) (amavisd-new, port 10024) with ESMTP id 22929-06; Wed, 23 Aug 2006 22:43:01 -0400 (EDT) Received: from bast.unixathome.org (bast.unixathome.org [70.26.229.230]) by m21.unixathome.org (Postfix) with ESMTP id 79A2FBF58; Wed, 23 Aug 2006 22:43:01 -0400 (EDT) Received: from [10.55.0.99] (wocker.unixathome.org [10.55.0.99]) by bast.unixathome.org (Postfix) with ESMTP id EA0DCB822; Wed, 23 Aug 2006 22:42:49 -0400 (EDT) From: "Dan Langille" To: Tom Lane Date: Wed, 23 Aug 2006 22:42:49 -0400 MIME-Version: 1.0 Subject: Re: Forcing index usage without 'enable_hashjoin = FALSE' Cc: Chris , pgsql-performance@postgresql.org Message-ID: <44ECD9E9.15840.1F152338@dan.langille.org> In-reply-to: <28098.1156386616@sss.pgh.pa.us> References: <44ECD283.18248.1EF83D45@dan.langille.org> X-mailer: Pegasus Mail for Windows (4.31) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at unixathome.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200608/382 X-Sequence-Number: 20567 On 23 Aug 2006 at 22:30, Tom Lane wrote: > "Dan Langille" writes: > > Without leaving "enable_hashjoin = false", can you suggest a way to > > force the index usage? > > Have you tried reducing random_page_cost? Yes. No effect. > FYI, 8.2 should be a bit better about this. Good. This query is not critical, but it would be nice. Thank you. -- Dan Langille : Software Developer looking for work my resume: http://www.freebsddiary.org/dan_langille.php