MIME-Version: 1.0
References: 
 <CAJxTCxyUtQuESS+Nk3+HRwjirZrs9A6Ypis=XfPcVV0=siJ0Qg@mail.gmail.com>
In-Reply-To: 
 <CAJxTCxyUtQuESS+Nk3+HRwjirZrs9A6Ypis=XfPcVV0=siJ0Qg@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 9 May 2026 22:51:15 -0400
Message-ID: 
 <CANzqJaD5tdj2hjFi0Yeoy0GyVE5OaeY+k55oCOTOZ2o_Diq5+g@mail.gmail.com>
Subject: Re: fdw: foreign partition and aggregate function
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000cf19f106516db435"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaD5tdj2hjFi0Yeoy0GyVE5OaeY%2Bk55oCOTOZ2o_Diq5%2Bg%40mail.gmail.com>
Precedence: bulk

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

On Sat, May 9, 2026 at 5:49=E2=80=AFAM J=C3=A9r=C3=A9my Lal <kapouer@melix.=
org> wrote:

> Hi,
>
> Using PostgreSQL on Debian 18.3-1.pgdg13+1
>
> I've setup a partitioned table, with local and foreign partitions like th=
is
> Cl=C3=A9 de partition : LIST (part_id)
> Partitions: foreign_parts_s1.mytable_1 FOR VALUES IN (1), FOREIGN,
>             parts_s10.mytable_10 FOR VALUES IN (10), PARTITIONED,
>
> and ran ANALYZE mytable;
>

pg_stat_all_tables will tell you if remote parts_s1.mytable_1 was really
analyzed.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Sat, May 9, 2026 at 5:49=E2=80=AFAM J=
=C3=A9r=C3=A9my Lal &lt;<a href=3D"mailto:kapouer@melix.org">kapouer@melix.=
org</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><b=
lockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-le=
ft:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=
=3D"ltr">Hi,<div><br></div><div>Using PostgreSQL on Debian 18.3-1.pgdg13+1<=
/div><div><br></div><div>I&#39;ve setup a partitioned table, with local and=
 foreign partitions like this</div>Cl=C3=A9 de partition : LIST (part_id)<b=
r>Partitions: foreign_parts_s1.mytable_1 FOR VALUES IN (1), FOREIGN,<br><di=
v>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 parts_s10.mytable_10 FOR VALUES=
 IN (10), PARTITIONED,=C2=A0</div><div><br></div><div>and ran ANALYZE mytab=
le;</div></div></div></blockquote><div><br></div><div>pg_stat_all_tables wi=
ll tell you if remote parts_s1.mytable_1 was really analyzed.=C2=A0</div></=
div><div><br></div><span class=3D"gmail_signature_prefix">-- </span><br><di=
v dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redac=
ted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><=
div><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>

--000000000000cf19f106516db435--