MIME-Version: 1.0
References: 
 <CAJxTCxyUtQuESS+Nk3+HRwjirZrs9A6Ypis=XfPcVV0=siJ0Qg@mail.gmail.com>
 <CANzqJaD5tdj2hjFi0Yeoy0GyVE5OaeY+k55oCOTOZ2o_Diq5+g@mail.gmail.com>
In-Reply-To: 
 <CANzqJaD5tdj2hjFi0Yeoy0GyVE5OaeY+k55oCOTOZ2o_Diq5+g@mail.gmail.com>
From: =?UTF-8?B?SsOpcsOpbXkgTGFs?= <kapouer@melix.org>
Date: Tue, 12 May 2026 10:09:46 +0200
Message-ID: 
 <CAJxTCxw6X4G8wpW-41Md0sf5pn=aVCLXC9=H71v_xLa5_xnGPA@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="0000000000000f2cb506519a652c"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJxTCxw6X4G8wpW-41Md0sf5pn%3DaVCLXC9%3DH71v_xLa5_xnGPA%40mail.gmail.com>
Precedence: bulk

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

Le dim. 10 mai 2026 =C3=A0 04:51, Ron Johnson <ronljohnsonjr@gmail.com> a =
=C3=A9crit :

> On Sat, May 9, 2026 at 5:49=E2=80=AFAM J=C3=A9r=C3=A9my Lal <kapouer@meli=
x.org> wrote:
>
>> Hi,
>>
>> Using PostgreSQL on Debian 18.3-1.pgdg13+1
>>
>> I've setup a partitioned table, with local and foreign partitions like
>> this
>> 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.
>

Thanks, I searched into that direction.
pg_stat_all_tables doesn't have any stat regarding parts_s1.mytable_1:
    SELECT relname FROM pg_stat_all_tables WHERE relname LIKE '%mytable%';
only returns relname my_table, mytable_10

Anyway, analyze verbose reports nothing suspicious, with entry like
INFO:  analyzing "foreign_parts_s1.mytable_1"
INFO:  "mytable_1": table contains 6320 rows, 6320 rows in sample
INFO:  finished analyzing table "mydb.foreign_parts_s1.mytable_1"


mydb=3D# SELECT
schemaname, tablename, attname, inherited, n_distinct, most_common_vals
FROM pg_stats WHERE tablename =3D 'mytable' AND attname =3D 'part_id';
-[ RECORD 1
]-----+--------------------------------------------------------------------=
--
schemaname        | public
tablename         | mytable
attname           | part_id
inherited         | t
n_distinct        | 1
most_common_vals  | {10}

most_common_vals only list local partition's list value.
That seems not okay.

To be honest, the partitions are themselves partitioned with another
column, so maybe it causes an issue.

J=C3=A9r=C3=A9my

>

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote g=
mail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">Le=C2=A0dim. 10=
 mai 2026 =C3=A0=C2=A004:51, Ron Johnson &lt;<a href=3D"mailto:ronljohnsonj=
r@gmail.com">ronljohnsonjr@gmail.com</a>&gt; a =C3=A9crit=C2=A0:<br></div><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex"><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" target=3D"_blank">kapouer@melix.org</a>&=
gt; wrote:</div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left: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;v=
e setup a partitioned table, with local and foreign partitions like this</d=
iv>Cl=C3=A9 de partition : LIST (part_id)<br>Partitions: foreign_parts_s1.m=
ytable_1 FOR VALUES IN (1), FOREIGN,<br><div>=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 mytable;</div></div></div></blockqu=
ote><div><br></div><div>pg_stat_all_tables will tell you if remote parts_s1=
.mytable_1 was really analyzed.=C2=A0</div></div></div></blockquote><div><b=
r></div><div>Thanks, I searched into that direction.</div><div>pg_stat_all_=
tables doesn&#39;t have any stat regarding parts_s1.mytable_1:<br>=C2=A0 =
=C2=A0 SELECT relname=C2=A0FROM pg_stat_all_tables WHERE relname LIKE &#39;=
%mytable%&#39;;<br>only returns relname my_table, mytable_10</div><div><br>=
</div><div>Anyway, analyze verbose reports nothing suspicious, with entry l=
ike<br>INFO: =C2=A0analyzing &quot;foreign_parts_s1.mytable_1&quot;<br>INFO=
: =C2=A0&quot;mytable_1&quot;: table contains 6320 rows, 6320=C2=A0rows in =
sample<br>INFO: =C2=A0finished analyzing table &quot;mydb.foreign_parts_s1.=
mytable_1&quot;<br><br><br>mydb=3D# SELECT schemaname,=C2=A0tablename,=C2=
=A0attname,=C2=A0inherited,=C2=A0n_distinct,=C2=A0most_common_vals FROM pg_=
stats WHERE=C2=A0tablename =3D &#39;mytable&#39;=C2=A0AND attname =3D &#39;=
part_id&#39;;<br>-[ RECORD 1 ]-----+---------------------------------------=
-------------------------------<br>schemaname =C2=A0 =C2=A0 =C2=A0 =C2=A0| =
public<br>tablename =C2=A0 =C2=A0 =C2=A0 =C2=A0 | mytable<br>attname =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | part_id<br>inherited =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 | t<br>n_distinct =C2=A0 =C2=A0 =C2=A0 =C2=A0| 1<br>most_common_vals=
 =C2=A0| {10}<br><br></div><div>most_common_vals only list local partition&=
#39;s list value.</div><div>That seems not okay.<br></div><div><br></div><d=
iv>To be honest, the partitions are themselves partitioned with another col=
umn, so maybe it causes an issue.<br><br>J=C3=A9r=C3=A9my</div><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex">
</blockquote></div></div>

--0000000000000f2cb506519a652c--