Re: Forcing index usage without 'enable_hashjoin = FALSE'

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Dan Langille" <dan@xxxxxxxxxxxx>
Subject: Re: Forcing index usage without 'enable_hashjoin = FALSE'
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Wed, 23 Aug 2006 22:30:16 -0400
Cc: Chris <dmagick@xxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
Comments: In-reply-to "Dan Langille" <dan@xxxxxxxxxxxx> message dated "Wed, 23 Aug 2006 22:11:15 -0400"
In-reply-to: <44ECD283.18248.1EF83D45@xxxxxxxxxxxxxxxx>
References: <44EA9190.5306.162A8DE9@xxxxxxxxxxxxxxxx> <44ECD283.18248.1EF83D45@xxxxxxxxxxxxxxxx>

"Dan Langille" <dan@xxxxxxxxxxxx> 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

Follow-Ups:
- Re: Forcing index usage without 'enable_hashjoin = FALSE'
  - From: Dan Langille

References:
- Forcing index usage without 'enable_hashjoin = FALSE'
  - From: Dan Langille
- Re: Forcing index usage without 'enable_hashjoin = FALSE'
  - From: Dan Langille

Prev by Date: Re: Forcing index usage without 'enable_hashjoin = FALSE'
Next by Date: Re: Forcing index usage without 'enable_hashjoin = FALSE'
Previous by thread: Re: Forcing index usage without 'enable_hashjoin = FALSE'
Next by thread: Re: Forcing index usage without 'enable_hashjoin = FALSE'
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux