Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Forcing index usage without 'enable_hashjoin = FALSE'
Date
Msg-id 28098.1156386616@sss.pgh.pa.us
Whole thread Raw
In response to Re: Forcing index usage without 'enable_hashjoin = FALSE'  ("Dan Langille" <dan@langille.org>)
Responses Re: Forcing index usage without 'enable_hashjoin = FALSE'
List pgsql-performance
Tree view 
"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?

FYI, 8.2 should be a bit better about this.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Dan Langille"
Date:
Subject: Re: Forcing index usage without 'enable_hashjoin = FALSE'
Next
From: "Dan Langille"
Date:
Subject: Re: Forcing index usage without 'enable_hashjoin = FALSE'