How to uses self query plan - Mailing list pgsql-admin

From olivier.boissard@cerene.fr
Subject How to uses self query plan
Date
Msg-id 476847DB.9090401@cerene.fr
Whole thread Raw
Responses Re: How to uses self query plan  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Set maintenance work mem for pg_restore
Next
From: Deron
Date:
Subject: Re: Set maintenance work mem for pg_restore