pg_dump -Are statistics saved? - Mailing list pgsql-admin

From Murthy Nunna
Subject pg_dump -Are statistics saved?
Date
Msg-id DM8PR09MB6677154B85D10BF16F8379CBB8BCA@DM8PR09MB6677.namprd09.prod.outlook.com
Whole thread Raw
Responses Re: pg_dump -Are statistics saved?
Re: pg_dump -Are statistics saved?
List 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 by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: PGAdmin 8 - Tabs
Next
From: "David G. Johnston"
Date:
Subject: Re: pg_dump -Are statistics saved?