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.phphttp://archives.postgresql.org/pgsql-hackers/2006-10/msg00517.phphttp://archives.postgresql.org/pgsql-hackers/2006-10/msg00663.php
Regards
Pavel Stehule
> Sincerely yours
> Anuar