Обсуждение: Auto-analyse vs manual analyze

Hello,
Is there a difference between an autoanalyze and a manual analyze ?
I got an error when I simply select from a function

HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 CONTEXT:  SQL function "test_v1" during startup automatic analyze of table « table"

A simple manual analyze resolved my problem.

Thank you
My

Mai Peng <maily.peng@webedia-group.com> writes:
> Is there a difference between an autoanalyze and a manual analyze ?

autoanalyze runs with a restrictive search_path setting.

> I got an error when I simply select from a function

This suggests that your function isn't being sufficiently careful
to schema-qualify names it uses.  (If you don't want to change the
function text, adding a SET clause to force the desired search_path
would work, though it does carry a bit of performance penalty.)

            regards, tom lane