Re: ANALYZE post-upgrade

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Edwin UY <edwin(dot)uy(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: ANALYZE post-upgrade
Date: 2025-02-26 04:58:30
Message-ID: 1706947.1740545910@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Edwin UY <edwin(dot)uy(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gayu thulasi 2025-02-26 05:07:24 Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL
Previous Message Edwin UY 2025-02-26 04:39:25 ANALYZE post-upgrade