Date: Thu, 28 Dec 2023 12:37:16 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Corey Huinker <corey.huinker@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
	Tomas Vondra <tomas.vondra@enterprisedb.com>,
	Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>,
	pgsql-hackers@lists.postgresql.org
Subject: Re: Statistics Import and Export
Message-ID: <ZY2yTDqdFPf6Rw8f@momjian.us>
References: 
 <CADkLM=cx-XM-PTscj+uDi24x3_vDpYMOjfHgw9CFt_ad5poc0A@mail.gmail.com>
 <76596388-6fe6-0baf-351d-734458a46d76@enterprisedb.com>
 <CADkLM=frTx5DocOpyhRHL4r_LKvP315cNA-5+0UVqGM=7GKd9A@mail.gmail.com>
 <4268d862-7784-f76f-d7f1-359b0b4db67c@enterprisedb.com>
 <ZYsYMqukg97HdB7u@momjian.us>
 <2090613.1703618344@sss.pgh.pa.us>
 <4e49c72e-f8a5-de1a-4ef4-36529bee1d65@enterprisedb.com>
 <CADkLM=ff8BsPCvigT+xooPPBy4mCyu6pGdR=_e6ew=gR7bpCGA@mail.gmail.com>
 <2788275.1703733025@sss.pgh.pa.us>
 <CADkLM=em7HteSgn9tCzioko0+hx00a+kr2WXKWkb7zye7wA8Yg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CADkLM=em7HteSgn9tCzioko0+hx00a+kr2WXKWkb7zye7wA8Yg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZY2yTDqdFPf6Rw8f%40momjian.us>
Precedence: bulk

On Thu, Dec 28, 2023 at 12:28:06PM -0500, Corey Huinker wrote:
>     What I am proposing is *import* functions.  I didn't say anything about
>     how pg_dump obtains the data it prints; however, I would advocate that
>     we keep that part as simple as possible.  You cannot expect export
>     functionality to know the requirements of future server versions,
>     so I don't think it's useful to put much intelligence there.
> 
> True, but presumably you'd be using the pg_dump/pg_upgrade of that future
> version to do the exporting, so the export format would always be tailored to
> the importer's needs.

I think the question is whether we will have the export functionality in
the old cluster, or if it will be queries run by pg_dump and therefore
also run by pg_upgrade calling pg_dump.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.