Re: Forcing index usage without 'enable_hashjoin = FALSE'

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

 



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

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

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




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

  Powered by Linux