Re: pgsql: Transfer statistics during pg_upgrade.

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Jeff Davis <jdavis(at)postgresql(dot)org>, Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Transfer statistics during pg_upgrade.
Date: 2025-04-08 05:24:38
Message-ID: CAApHDvow5dz1=p1QNb+BQV4eaA75j6qmmhpi9j2yFzwcd4pE3Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

On Thu, 20 Feb 2025 at 22:29, Jeff Davis <jdavis(at)postgresql(dot)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

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message David Rowley 2025-04-08 06:10:18 pgsql: Speedup child EquivalenceMember lookup in planner
Previous Message Amit Kapila 2025-04-08 04:23:16 pgsql: Stabilize 035_standby_logical_decoding.pl.