Tell postgres which index to use?

Поиск
Список
Период
Сортировка
От Silke Trissl
Тема Tell postgres which index to use?
Дата
Msg-id 420A3309.5040507@informatik.hu-berlin.de
обсуждение исходный текст
Ответы Re: Tell postgres which index to use?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Hi,

is there a way to tell Postgres which index to use when a query is
issued in 7.4.2?

I have a query for which costwise a Hash-Join and no Index-Usage is the
best, but timewise using the index and then do a NestedLoop join is much
better (3 - 4 times).

I have vacuumed before I started the comparison, so Postgres does its
best. And I don't constantly want to switch on and off the hashjoin and
mergejoin.

Regards,

Silke Trissl



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

Предыдущее
От: John A Meinel
Дата:
Сообщение: Re: How can I make use of both CPUs in a dual processor
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Tell postgres which index to use?