How to uses self query plan

Поиск
Список
Период
Сортировка
От olivier.boissard@cerene.fr
Тема How to uses self query plan
Дата
Msg-id 476847DB.9090401@cerene.fr
обсуждение исходный текст
Ответы Re: How to uses self query plan  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-admin
Hello,

My purpose is to uses different query plan depending on queries
I got the following problem : some queries are taking too much time and
postgresql does not take the most relevant index in account.
I search on internet and found that no HINT function was available in
postgresl.
I tried to change indexes parameters in postgresql.conf but eache time I
set a param to OFF (example nested_loop ,seqscan, ...) , some queries
freeze database .

How can we force postgresql to use a plan ?

olivier

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Set maintenance work mem for pg_restore
Следующее
От: Deron
Дата:
Сообщение: Re: Set maintenance work mem for pg_restore