Re: pg_dump -Are statistics saved?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Murthy Nunna <mnunna(at)fnal(dot)gov>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_dump -Are statistics saved?
Date: 2023-11-28 00:31:47
Message-ID: CAKFQuwbvODyXYZx61M6kpXzh0JbiLASA+rtGd0S1LM1EdmN-wg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Nov 27, 2023 at 5:28 PM Murthy Nunna <mnunna(at)fnal(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2023-11-28 00:45:45 Re: pg_dump -Are statistics saved?
Previous Message Murthy Nunna 2023-11-28 00:28:05 pg_dump -Are statistics saved?