Re: Forcing index usage without 'enable_hashjoin = FALSE'

From: "Dan Langille" <dan(at)langille(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Chris <dmagick(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Forcing index usage without 'enable_hashjoin = FALSE'
Date: 2006-08-24 02:42:49
Message-ID: 44ECD9E9.15840.1F152338@dan.langille.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

> "Dan Langille" <dan(at)langille(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Subbiah, Stalin 2006-08-24 04:44:20 Re: [PERFORM] Query tuning
Previous Message Tom Lane 2006-08-24 02:30:16 Re: Forcing index usage without 'enable_hashjoin = FALSE'