From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mai Peng <maily.peng@webedia-group.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Auto-analyse vs manual analyze
Date: Tue, 08 Dec 2020 12:11:43 -0500
Message-ID: <3256926.1607447503@sss.pgh.pa.us> (raw)
In-Reply-To: <48106937-7FA8-4868-887C-EE697E422DB0@webedia-group.com>
References: <48106937-7FA8-4868-887C-EE697E422DB0@webedia-group.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, maily.peng@webedia-group.com, pgsql-admin@lists.postgresql.org
Subject: Re: Auto-analyse vs manual analyze
In-Reply-To: <3256926.1607447503@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox