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

From Ron Johnson
Subject Re: ANALYZE post-upgrade
Date
Msg-id CANzqJaDyoFpw5nrTcf8-cpAo_R_QvJTcqRrFNLdxS1zStRRr2g@mail.gmail.com
Whole thread Raw
In response to ANALYZE post-upgrade  (Edwin UY <edwin.uy@gmail.com>)
List pgsql-admin
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!

pgsql-admin by date:

Previous
From: Mahendra Singh
Date:
Subject: Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL
Next
From: Juan Rincon Gonzalez
Date:
Subject: Re: Hot Standby setup - collation version mismatch