Re: Forcing index usage without 'enable_hashjoin = FALSE'

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dan Langille" <dan(at)langille(dot)org>
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:30:16
Message-ID: 28098.1156386616@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"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?

FYI, 8.2 should be a bit better about this.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dan Langille 2006-08-24 02:42:49 Re: Forcing index usage without 'enable_hashjoin = FALSE'
Previous Message Dan Langille 2006-08-24 02:11:15 Re: Forcing index usage without 'enable_hashjoin = FALSE'