Postgres Pro
Downloads
Home   >   mailing lists

Re: ANALYZE post-upgrade - Mailing list pgsql-admin

From Tom Lane
Subject Re: ANALYZE post-upgrade
Date
Msg-id 1706947.1740545910@sss.pgh.pa.us
Whole thread Raw
In response to ANALYZE post-upgrade  (Edwin UY <edwin.uy@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Edwin UY
Date:
Subject: ANALYZE post-upgrade
Next
From: Gayu thulasi
Date:
Subject: Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL