pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: Corey Huinker <corey.huinker@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Statistics Import and Export
Date: Thu, 28 Dec 2023 12:37:16 -0500
Message-ID: <ZY2yTDqdFPf6Rw8f@momjian.us> (raw)
In-Reply-To: <CADkLM=em7HteSgn9tCzioko0+hx00a+kr2WXKWkb7zye7wA8Yg@mail.gmail.com>
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>

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.





view thread (543+ messages)  latest in thread

Message-ID: <ZY2yTDqdFPf6Rw8f@momjian.us>
Permalink:  ../ZY2yTDqdFPf6Rw8f@momjian.us/
Also on:    postgresql.org/message-id/ZY2yTDqdFPf6Rw8f@momjian.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: bruce@momjian.us, corey.huinker@gmail.com, tgl@sss.pgh.pa.us, tomas.vondra@enterprisedb.com, ashutosh.bapat.oss@gmail.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: Statistics Import and Export
  In-Reply-To: <ZY2yTDqdFPf6Rw8f@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox