Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D6C8C2E32A6 for ; Tue, 18 Dec 2007 18:21:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21759-04 for ; Tue, 18 Dec 2007 18:21:19 -0400 (AST) Received: from mx2.imatech.net (mx2.imatech.net [81.255.215.243]) by postgresql.org (Postfix) with ESMTP id 96A3D2E3291 for ; Tue, 18 Dec 2007 18:21:18 -0400 (AST) Received: from mx.imatech.net ([81.255.215.253]:2757) by mx2.imatech.net with [XMail 1.23 ESMTP Server] id for from ; Mon, 17 Dec 2007 22:41:52 +0100 X-AuthUser: olivier.boissard@cerene.fr Received: from [192.168.0.11] ([88.161.145.183]:1204) by mx.imatech.net with [XMail 1.23 ESMTP Server] id for from ; Tue, 18 Dec 2007 23:21:06 +0100 Message-ID: <476847DB.9090401@cerene.fr> Date: Tue, 18 Dec 2007 23:21:15 +0100 From: "olivier.boissard@cerene.fr" User-Agent: Thunderbird 1.5.0.13 (Windows/20070809) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: How to uses self query plan Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/173 X-Sequence-Number: 27690 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