Re: When manual analyze is needed - Mailing list pgsql-general

From Tom Lane
Subject Re: When manual analyze is needed
Date
Msg-id 3494986.1709526671@sss.pgh.pa.us
Whole thread Raw
In response to Re: When manual analyze is needed  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> The only things that require manual ANALYZE are
> ...

You missed one important exception: autovacuum/autoanalyze cannot
process temporary tables, because those are not accessible outside
the owning session.  So you need to do those manually if it's
important for performance.

            regards, tom lane



pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Guarantees/Semantics of pg_stats
Next
From: veem v
Date:
Subject: Re: When manual analyze is needed