Re: Forcing index usage without 'enable_hashjoin = FALSE'

Поиск
Список
Период
Сортировка
От Dan Langille
Тема Re: Forcing index usage without 'enable_hashjoin = FALSE'
Дата
Msg-id 44ECD9E9.15840.1F152338@dan.langille.org
обсуждение исходный текст
Ответ на Re: Forcing index usage without 'enable_hashjoin = FALSE'  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On 23 Aug 2006 at 22:30, Tom Lane wrote:

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

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



В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Forcing index usage without 'enable_hashjoin = FALSE'
Следующее
От: "Subbiah, Stalin"
Дата:
Сообщение: Re: Query tuning