pg_dump -Are statistics saved?

Поиск
Список
Период
Сортировка
От Murthy Nunna
Тема pg_dump -Are statistics saved?
Дата
Msg-id DM8PR09MB6677154B85D10BF16F8379CBB8BCA@DM8PR09MB6677.namprd09.prod.outlook.com
обсуждение исходный текст
Ответы Re: pg_dump -Are statistics saved?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: pg_dump -Are statistics saved?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin

Hello,

 

We are running pg version 14.4

 

I did a pg_dump of a fairly large database (~20TB). I plan to pg_restore it on same server after upgrading Linux from Scientific Linux release 7.9 to Alma 9. We are forced to do pg_dump/pg_restore due to glibc collation changes in Alma 9.

 

The pg_dump (used verbose) log said “pg_dump: reading extended statistics”.

 

Does it mean it saved statistics and they can be restored with pg_restore? If not, is it necessary to run ANALYZE after pg_restore?

 

Thanks in advance for responding.

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Holger Jakobs
Дата:
Сообщение: Re: PGAdmin 8 - Tabs
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: pg_dump -Are statistics saved?