agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedANALYZE post-upgrade
3+ messages / 3 participants
[nested] [flat]
* ANALYZE post-upgrade
@ 2025-02-26 04:39 Edwin UY <edwin.uy@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Edwin UY @ 2025-02-26 04:39 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ANALYZE post-upgrade
@ 2025-02-26 04:58 Tom Lane <tgl@sss.pgh.pa.us>
parent: Edwin UY <edwin.uy@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2025-02-26 04:58 UTC (permalink / raw)
To: Edwin UY <edwin.uy@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ANALYZE post-upgrade
@ 2025-02-26 07:04 Ron Johnson <ronljohnsonjr@gmail.com>
parent: Edwin UY <edwin.uy@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Ron Johnson @ 2025-02-26 07:04 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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!
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-02-26 07:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-26 04:39 ANALYZE post-upgrade Edwin UY <edwin.uy@gmail.com>
2025-02-26 04:58 ` Tom Lane <tgl@sss.pgh.pa.us>
2025-02-26 07:04 ` Ron Johnson <ronljohnsonjr@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox