MIME-Version: 1.0
References: 
 <CAGA3vBt726ha1P91DrSOF8oc57X27tLO8o9Wi9oDN5L3qqRi7Q@mail.gmail.com>
 <d38e3d6b4287b9bc52a5236c184cb0a1df4cba6f.camel@cybertec.at>
 <CAGA3vBspwtKvaFBXT4c78cdW+mgfXJ68MSDL3TiVdMxpZPp_VA@mail.gmail.com>
 <155c25b62f6eab032138b93831ca4fe95158e059.camel@cybertec.at>
In-Reply-To: <155c25b62f6eab032138b93831ca4fe95158e059.camel@cybertec.at>
From: richard coleman <rcoleman.ascentgl@gmail.com>
Date: Tue, 1 Aug 2023 15:27:40 -0400
Message-ID: 
 <CAGA3vBvOOmrhpOJc3gjMcQS_TDfGR7OH_vaodLUQoJxYO8wZSQ@mail.gmail.com>
Subject: Re: analyze foreign tables
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000000f9230601e18b2a"
Archived-At: 
 <https://www.postgresql.org/message-id/CAGA3vBvOOmrhpOJc3gjMcQS_TDfGR7OH_vaodLUQoJxYO8wZSQ%40mail.gmail.com>
Precedence: bulk

--00000000000000f9230601e18b2a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Laurenz,

Since my ability to program in C is basically non-existent, there's no
danger of me writing custom PostgreSQL C code anytime soon.

Maybe someday when I retire I'll take up C coding to keep my mind nimble.

So increasing parallelization it is.

Thanks again,
rik.


On Tue, Aug 1, 2023 at 3:15=E2=80=AFPM Laurenz Albe <laurenz.albe@cybertec.=
at>
wrote:

> On Tue, 2023-08-01 at 12:36 -0400, richard coleman wrote:
> > Would it be possible to transfer table statistics between the same
> version
> > 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 catalo=
g
> tables,
> but you would probably need server C code for that, since you cannot
> normally
> 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
> helpful.
>
> Run the ANALYZE in many parallel sessions.  I cannot think of anything
> smarter.
>
> Yours,
> Laurenz Albe
>

--00000000000000f9230601e18b2a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Laurenz,=C2=A0<div><br></div><div>Since my ability to prog=
ram in C is basically non-existent, there&#39;s no danger of me writing cus=
tom PostgreSQL C code anytime soon.=C2=A0=C2=A0</div><div><br></div><div>Ma=
ybe someday when I retire I&#39;ll take up C coding to keep my mind nimble.=
</div><div><br></div><div>So increasing parallelization it is.</div><div><b=
r></div><div>Thanks again,=C2=A0</div><div>rik.</div><div><br></div></div><=
br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue,=
 Aug 1, 2023 at 3:15=E2=80=AFPM Laurenz Albe &lt;<a href=3D"mailto:laurenz.=
albe@cybertec.at">laurenz.albe@cybertec.at</a>&gt; wrote:<br></div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px=
 solid rgb(204,204,204);padding-left:1ex">On Tue, 2023-08-01 at 12:36 -0400=
, richard coleman wrote:<br>
&gt; Would it be possible to transfer table statistics between the same ver=
sion<br>
&gt; of PostgreSQL, ex: source is pg15, target is pg15?<br>
<br>
There is no support for that.<br>
<br>
If you know what you are doing, you might be able to mess with the catalog =
tables,<br>
but you would probably need server C code for that, since you cannot normal=
ly<br>
write to an &quot;anyarray&quot;.<br>
<br>
I wouldn&#39;t recommend to go that way.<br>
<br>
&gt; Otherwise, anything that can be done to speed this up would be very he=
lpful.<br>
<br>
Run the ANALYZE in many parallel sessions.=C2=A0 I cannot think of anything=
 smarter.<br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div>

--00000000000000f9230601e18b2a--