Re: When manual analyze is needed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: veem v <veema0000(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: When manual analyze is needed
Date: 2024-03-04 04:31:11
Message-ID: 3494986.1709526671@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message veem v 2024-03-04 04:46:35 Re: When manual analyze is needed
Previous Message Laurenz Albe 2024-03-04 04:14:23 Re: Guarantees/Semantics of pg_stats