Thread:

RGVhciBhZG1pbmlzdHJhdG9yLA0KDQpJIHdvdWxkIGxpa2UgdG8ga25vdyB3
aGV0aGVyIFBvc3RncmVTUUwgaGFzIHNvbWUgaGVscCB0aXBzIChoaW50cykg
Zm9yIA0KcXVlcnkgb3B0aW1pemVyIHRoYXQgY2FuIGhlbHAgdG8gdXNlIGl0
IG1vcmUgZWZmaWNpZW50bHkgKGZvciBpbnN0YW5jZSwgYXMgDQpPcmFjbGUg
aGFzIHN1Y2ggdGlwcyBmb3Igb3B0aW1pemVyIGFzID9oaW50Pyk/IElmIGl0
IGhhcywgc28sIHBsZWFzZSwgDQppbmZvcm0gbWUgYSB2ZXJzaW9uIChJIGtu
b3csIHRoYXQgOC4zIHZlcnNpb24gaGFzIG5vdCBzdWNoIGZlYXR1cmVzKS4g
SWYgDQppdCBoYXMgbm90LCBzbyB3aWxsIGJlIHRoZXJlIHN1Y2ggaGludHMg
aW4gdGhlIGZ1dHVyZSB2ZXJzaW9uPyANCg0KU2luY2VyZWx5IHlvdXJzDQpB
bnVhcg0K

Hello

2008/6/10  <A.Anibayev@astel.kz>:
>
> Dear administrator,
>
> I would like to know whether PostgreSQL has some help tips (hints) for query
> optimizer that can help to use it more efficiently (for instance, as Oracle
> has such tips for optimizer as "hint")? If it has, so, please, inform me a
> version (I know, that 8.3 version has not such features). If it has not, so
> will be there such hints in the future version?
>

PostgreSQL doesn't use hints - and there are not plan to change it
Features We Do Not Want:
from ToDo:
Optimizer hints (not wanted)

Optimizer hints are used to work around problems in the optimizer. We
would rather have the problems reported and fixed.

http://archives.postgresql.org/pgsql-hackers/2006-08/msg00506.php
http://archives.postgresql.org/pgsql-hackers/2006-10/msg00517.php
http://archives.postgresql.org/pgsql-hackers/2006-10/msg00663.php

Regards
Pavel Stehule

> Sincerely yours
> Anuar