MIME-Version: 1.0
References: 
 <CAGA3vBt726ha1P91DrSOF8oc57X27tLO8o9Wi9oDN5L3qqRi7Q@mail.gmail.com>
 <615ccd4a1de716c229cf125260896051b1989608.camel@cybertec.at>
In-Reply-To: <615ccd4a1de716c229cf125260896051b1989608.camel@cybertec.at>
From: richard coleman <rcoleman.ascentgl@gmail.com>
Date: Thu, 3 Aug 2023 09:02:45 -0400
Message-ID: 
 <CAGA3vBtuVp7J7_U+DxznKEggX4n=F4tqGGde6U2VgexVcqCDHw@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="0000000000001e835206020466de"
Archived-At: 
 <https://www.postgresql.org/message-id/CAGA3vBtuVp7J7_U%2BDxznKEggX4n%3DF4tqGGde6U2VgexVcqCDHw%40mail.gmail.com>
Precedence: bulk

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

Laurenz,

That's great news.  Now if only transparent data encryption also arrives in
PostgreSQL 16, it will be a time for celebration.

rik.

On Thu, Aug 3, 2023 at 8:37=E2=80=AFAM Laurenz Albe <laurenz.albe@cybertec.=
at>
wrote:

> On Tue, 2023-08-01 at 09:47 -0400, richard coleman wrote:
> > In PostgreSQL foreign tables are not automatically analyzed and analyze
> must be
> > specifically called on each table.  In the case of sharing tables
> between PostgreSQL
> > clusters, there is the use_remote_estimate foreign server option.
> >
> > In some of our multi terabyte databases, manually running analyze on al=
l
> of the
> > foreign tables can take more than a day.  This is per database
> containing the
> > foreign schema.  Since we have certain large schema that we have
> centrally located
> > and share to all of our other database clusters, this really adds up.
>
> I just saw that PostgreSQL v16 uses remote sampling for ANALYZE on foreig=
n
> tables.
> This is governed by the option "analyze_sampling" on the foreign table or
> the foreign
> server, and the default value "auto" should be just what you need.
>
> Yours,
> Laurenz Albe
>

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

<div dir=3D"ltr">Laurenz,=C2=A0<div><br></div><div>That&#39;s great news.=
=C2=A0 Now if only transparent data encryption also arrives in PostgreSQL 1=
6, it will be a time for celebration.</div><div><br></div><div>rik.</div></=
div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On=
 Thu, Aug 3, 2023 at 8:37=E2=80=AFAM Laurenz Albe &lt;<a href=3D"mailto:lau=
renz.albe@cybertec.at">laurenz.albe@cybertec.at</a>&gt; wrote:<br></div><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex">On Tue, 2023-08-01 at 09:47 =
-0400, richard coleman wrote:<br>
&gt; In PostgreSQL foreign tables are not automatically analyzed and analyz=
e must be<br>
&gt; specifically called on each table.=C2=A0 In the case of sharing tables=
 between PostgreSQL<br>
&gt; clusters, there is the=C2=A0use_remote_estimate foreign server option.=
<br>
&gt; <br>
&gt; In some of our multi terabyte databases, manually running analyze on a=
ll of the<br>
&gt; foreign tables can take more than a day.=C2=A0 This is per database co=
ntaining the<br>
&gt; foreign schema.=C2=A0 Since we have certain large schema that we have =
centrally located<br>
&gt; and share to all of our other database clusters, this really adds up.<=
br>
<br>
I just saw that PostgreSQL v16 uses remote sampling for ANALYZE on foreign =
tables.<br>
This is governed by the option &quot;analyze_sampling&quot; on the foreign =
table or the foreign<br>
server, and the default value &quot;auto&quot; should be just what you need=
.<br>
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div>

--0000000000001e835206020466de--