Auto-analyse vs manual analyze

From: Mai Peng <maily(dot)peng(at)webedia-group(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Auto-analyse vs manual analyze
Date: 2020-12-08 17:00:07
Message-ID: 48106937-7FA8-4868-887C-EE697E422DB0@webedia-group.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2020-12-08 17:11:43 Re: Auto-analyse vs manual analyze
Previous Message Scott Ribe 2020-12-08 14:29:51 Re: reindexing db