From: Tom Lane <tgl@sss.pgh.pa.us>
To: Holger Jakobs <holger@jakobs.com>
Cc: [PGSQL-ADMIN-LIST] <pgsql-admin@postgresql.org>
Subject: Re: Export and import of statistics data
Date: Tue, 23 Feb 2021 14:32:30 -0500
Message-ID: <3891953.1614108750@sss.pgh.pa.us> (raw)
In-Reply-To: <b97f9345-e617-e555-a6e9-7b185f2b17e2@jakobs.com>
References: <b97f9345-e617-e555-a6e9-7b185f2b17e2@jakobs.com>
Holger Jakobs <holger@jakobs.com> writes:
> Is there a way of exporting statistics data from a database cluster
> containing a lot of rows and import them into a similar structured, but
> small database cluster.
Not at present, AFAIK. There have been discussions of creating a
way to do that, and I know of at least one non-public tool that
does it, but nobody's pushed things to the point of having code
the community would accept.
The key stumbling block is inventing a dump representation that
would have realistic prospects of still being importable if/when
we change the contents of pg_statistic. Certainly there are a
lot of applications where cross-version compatibility isn't a
requirement; but I don't think the community would take code that
isn't usable by pg_upgrade, and for that you need an upgradable
design.
regards, tom lane
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, holger@jakobs.com
Subject: Re: Export and import of statistics data
In-Reply-To: <3891953.1614108750@sss.pgh.pa.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