Thread: ANALYZE post-upgrade
Hi,
Just being paranoid here, sorry for a dumb question of sorts.
The ANALYZE run post upgrade, that doesn't include having to run it on the postgres database, does it?
It is only for the databases that you manually created for your application?
Edwin UY <edwin.uy@gmail.com> writes:
> The ANALYZE run post upgrade, that doesn't include having to run it on the
> postgres database, does it?
> It is only for the databases that you manually created for your application?
You'd want to run it on any database with non-default contents.
If you've created user tables in the postgres DB, they'd need
analyzed.
regards, tom lane
On Tue, Feb 25, 2025 at 11:40 PM Edwin UY <edwin.uy@gmail.com> wrote:
Hi,Just being paranoid here, sorry for a dumb question of sorts.The ANALYZE run post upgrade, that doesn't include having to run it on the postgres database, does it?It is only for the databases that you manually created for your application?
The postgres database is soooo tiny, an after-pg_upgrade ANALYZE of that table would take seconds at most, unless you unwisely put user tables in the database? IOW, don't worry whether or not it gets initially analyzed.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!