Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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