Message-ID: <155c25b62f6eab032138b93831ca4fe95158e059.camel@cybertec.at>
Subject: Re: analyze foreign tables
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: richard coleman <rcoleman.ascentgl@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Date: Tue, 01 Aug 2023 21:15:23 +0200
In-Reply-To: 
 <CAGA3vBspwtKvaFBXT4c78cdW+mgfXJ68MSDL3TiVdMxpZPp_VA@mail.gmail.com>
References: 
	<CAGA3vBt726ha1P91DrSOF8oc57X27tLO8o9Wi9oDN5L3qqRi7Q@mail.gmail.com>
	 <d38e3d6b4287b9bc52a5236c184cb0a1df4cba6f.camel@cybertec.at>
	 <CAGA3vBspwtKvaFBXT4c78cdW+mgfXJ68MSDL3TiVdMxpZPp_VA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/155c25b62f6eab032138b93831ca4fe95158e059.camel%40cybertec.at>
Precedence: bulk

On Tue, 2023-08-01 at 12:36 -0400, richard coleman wrote:
> Would it be possible to transfer table statistics between the same versio=
n
> of PostgreSQL, ex: source is pg15, target is pg15?

There is no support for that.

If you know what you are doing, you might be able to mess with the catalog =
tables,
but you would probably need server C code for that, since you cannot normal=
ly
write to an "anyarray".

I wouldn't recommend to go that way.

> Otherwise, anything that can be done to speed this up would be very helpf=
ul.

Run the ANALYZE in many parallel sessions.  I cannot think of anything smar=
ter.

Yours,
Laurenz Albe