From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | A(dot)Anibayev(at)astel(dot)kz |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: |
Date: | 2008-06-10 11:05:06 |
Message-ID: | 162867790806100405m685619d1s62a1cba74c46634b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello
2008/6/10 <A(dot)Anibayev(at)astel(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Lawrence Cohan | 2008-06-10 18:44:31 | BUG #4232: CREATE INDEX CONCURRENTLY |
Previous Message | A.Anibayev | 2008-06-10 04:45:17 |