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

From David G. Johnston
Subject Re: pg_dump -Are statistics saved?
Date
Msg-id CAKFQuwbvODyXYZx61M6kpXzh0JbiLASA+rtGd0S1LM1EdmN-wg@mail.gmail.com
Whole thread Raw
In response to pg_dump -Are statistics saved?  (Murthy Nunna <mnunna@fnal.gov>)
List pgsql-admin
On Mon, Nov 27, 2023 at 5:28 PM Murthy Nunna <mnunna@fnal.gov> wrote:

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?

 


Logical dumps do not output system catalogs except large objects.  It outputs object definitions In SQL form.  Though I'm unsure of that specific message.

David J.

pgsql-admin by date:

Previous
From: Murthy Nunna
Date:
Subject: pg_dump -Are statistics saved?
Next
From: Tom Lane
Date:
Subject: Re: pg_dump -Are statistics saved?