Scott Marlowe a écrit :
On Dec 18, 2007 4:21 PM, olivier.boissard@xxxxxxxxx
<olivier.boissard@xxxxxxxxx> wrote:
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 ?
That's not how we do things in postgresql land (usually).
You should figure out WHY your queries are picking the wrong plan, and
then see if you can get them to pick the right ones. If it's a query
planner bug, you report it here, or the perform or general lists, and
it gets fixed. Generic hints aren't likely to happen any time soon,
although I do believe 8.3 is introducing function costing of some
kind, which seems like a useful idea.
But, back to fixing your slow queries.
1: Increase statistics targets on the guilty columns and reanalyze.
2: Run explain analyze select.... and post the output here.
3: ???
4: profit?
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
Thanks for reply
I will extract some queries.
I want to precise that I use postgresql 8.1.0 .
Olivier
begin:vcard
fn:Olivier Boissard
n:Boissard;Olivier
org;quoted-printable:CERENE SERVICES;d=C3=A9veloppement
adr:;;3 rue archimede;La Chapelle Saint Luc;AUBE;10600;FRANCE
email;internet:olivier.boissard@xxxxxxxxx
tel;work:+33.3.25.74.11.78
tel;fax:+33.3.25.78.39.67
note;quoted-printable:"Ce message peut contenir des informations confidentielles et/ou=0D=0A=
prot=C3=A9g=C3=A9es. Il est =C3=A0 l'usage exclusif de son destinataire.=
Toute=0D=0A=
utilisation non autoris=C3=A9e peut =C3=AAtre illicite. Si vous recevez=
ce=0D=0A=
message par erreur, nous vous remercions d'en aviser imm=C3=A9diatement=0D=0A=
l'exp=C3=A9diteur en utilisant la fonction r=C3=A9ponse de votre gestionn=
aire=0D=0A=
de courrier =C3=A9lectronique."=0D=0A=
=0D=0A=
"This email may contain confidential information and/or copyright=0D=0A=
material. This email is intended for the use of the addressee only.=0D=0A=
Any unauthorised use may be unlawful. If you receive this email by=0D=0A=
mistake, please advise the sender immediately by using the reply=0D=0A=
facility in your email software."
url:www.cerene.fr
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
