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
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 ?
pgsql-admin by date
|Next:||From: Deron||Date: 2007-12-18 22:40:43|
|Subject: Re: Set maintenance work mem for pg_restore|
|Previous:||From: Tom Lane||Date: 2007-12-18 21:21:47|
|Subject: Re: Set maintenance work mem for pg_restore |