Re: ANALYZE post-upgrade

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: ANALYZE post-upgrade
Дата
Msg-id CANzqJaDyoFpw5nrTcf8-cpAo_R_QvJTcqRrFNLdxS1zStRRr2g@mail.gmail.com
обсуждение исходный текст
Ответ на ANALYZE post-upgrade  (Edwin UY <edwin.uy@gmail.com>)
Список 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 по дате отправления: