Re: Statistics Import and Export - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Statistics Import and Export
Date
Msg-id 6886e8bffbccf14766ba66c08ca4bcc174c1c1d8.camel@j-davis.com
Whole thread Raw
In response to Re: Statistics Import and Export  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: Statistics Import and Export
List pgsql-hackers
On Wed, 2025-05-21 at 11:08 -0500, Nathan Bossart wrote:
> On Tue, May 20, 2025 at 10:32:39AM -0700, Hari Krishna Sunder wrote:
> > Ah ya, forgot that reltuples are not always accurate. This sounds
> > reasonable to me.
>
> Cool.  Here is what I have staged for commit, which I am planning to
> do
> shortly.

Originally, one of the reasons we added a version field during dump is
so that some future version could reinterpret stats in older dump files
during import.

This patch is using a newer version of pg_dump to interpret stats from
older versions during export. That might be fine, but it would be good
to understand where the line is between things we should reinterpret
during export vs things we should reinterpret during import.

Regards,
    Jeff Davis




pgsql-hackers by date:

Previous
From: Anas-ur-Rasheed Khan
Date:
Subject: Feature Suggestion: Make synchronous_commit a table level property
Next
From: Jacob Champion
Date:
Subject: Re: Log connection establishment timings