Postgres Pro
Downloads
Home   >   mailing lists

PostgreSQL Database Upgrade - Mailing list pgsql-general

From github kran
Subject PostgreSQL Database Upgrade
Date
Msg-id CACaZr5QASoOPK7dyMCQAXZd5ZyoW5K3O4VrVW1y0zcrDXSxKfg@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL Database Upgrade  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view


Hello PostgreSQL Team, 

We have recently upgraded the postgreSQL version from V9 to V10. 
  • Is the below command right to update the database statistics after the database upgrade ?. 
  • How do I verify in PG_STATS if the Analyze ran successfully? Does it show any time when the last Analyze successfully completed.? 
Command used:
ANALYZE VERBOSE;


Appreciate your help, thank you !!

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PL/java
Next
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL Database Upgrade