Home > mailing lists

Re: Forcing index usage without 'enable_hashjoin = FALSE' - Mailing list pgsql-performance

From	Dan Langille
Subject	Re: Forcing index usage without 'enable_hashjoin = FALSE'
Date	August 24, 2006 02:43:05
Msg-id	44ECD9E9.15840.1F152338@dan.langille.org Whole thread Raw
In response to	Re: Forcing index usage without 'enable_hashjoin = FALSE' (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-performance

Tree view

On 23 Aug 2006 at 22:30, Tom Lane wrote:

> "Dan Langille" <dan@langille.org> 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

pgsql-performance by date:

From: Tom Lane
Date: 24 August 2006, 02:30:28
Subject: Re: Forcing index usage without 'enable_hashjoin = FALSE'

From: "Subbiah, Stalin"
Date: 24 August 2006, 04:44:43
Subject: Re: Query tuning

Re: Forcing index usage without 'enable_hashjoin = FALSE' - Mailing list pgsql-performance

Previous

Next