Re: pgsql: Transfer statistics during pg_upgrade. - Mailing list pgsql-committers

From David Rowley
Subject Re: pgsql: Transfer statistics during pg_upgrade.
Date
Msg-id CAApHDvow5dz1=p1QNb+BQV4eaA75j6qmmhpi9j2yFzwcd4pE3Q@mail.gmail.com
Whole thread Raw
In response to pgsql: Transfer statistics during pg_upgrade.  (Jeff Davis <jdavis@postgresql.org>)
Responses Re: pgsql: Transfer statistics during pg_upgrade.
List pgsql-committers
On Thu, 20 Feb 2025 at 22:29, Jeff Davis <jdavis@postgresql.org> wrote:
> Add support to pg_dump for dumping stats, and use that during
> pg_upgrade so that statistics are transferred during upgrade. In most
> cases this removes the need for a costly re-analyze after upgrade.

I was surprised to see when I did pg_dump -T just_this_table that I
also got statistics data for all tables in the database.

Have filtering stats for tables not in the -T list been overlooked?

David



pgsql-committers by date:

Previous
From: Amit Kapila
Date:
Subject: pgsql: Stabilize 035_standby_logical_decoding.pl.
Next
From: David Rowley
Date:
Subject: pgsql: Speedup child EquivalenceMember lookup in planner