Re:

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