Postgres Pro
Downloads
Home   >   mailing lists

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

From Hari Krishna Sunder
Subject Re: Statistics Import and Export
Date
Msg-id CAAeiqZ2CnY92Te_LJWXO0PMB9kxtLFGYeAyx_CUyquO6BAmhzg@mail.gmail.com
Whole thread Raw
In response to Re: Statistics Import and Export  (Corey Huinker <corey.huinker@gmail.com>)
Responses Re: Statistics Import and Export
List pgsql-hackers
Tree view
To improve the performance of pg_dump can we add a new sql function that can operate more efficiently than the pg_stats view? It could also take in an optional list of oids to filter on.
This will help speed up the dump and restore within pg18 and future upgrades to higher pg versions.

Thanks
Hari Krishna Sunder

On Fri, Mar 7, 2025 at 7:43 PM Corey Huinker <corey.huinker@gmail.com> wrote:
I tried to generalize that requirement to all of
{schema|data|statistics} for consistency, but that resulted in 9
options.

9 options that resolve to 3 boolean variables. It's not that hard.

And if we add a fourth option set, then we have 12 options. So it's O(3N), not O(N^2).

People have scripts now that rely on the existing -only flags, and nearly every other potentially optional thing has a -no flag. Let's leverage that.

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Parallel heap vacuum
Next
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: Selectively invalidate caches in pgoutput module