public inbox for pgsql-general@postgresql.org
help / color / mirror / Atom feedFrom: Jérémy Lal <kapouer@melix.org>
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: fdw: foreign partition and aggregate function
Date: Tue, 12 May 2026 10:09:46 +0200
Message-ID: <CAJxTCxw6X4G8wpW-41Md0sf5pn=aVCLXC9=H71v_xLa5_xnGPA@mail.gmail.com> (raw)
In-Reply-To: <CANzqJaD5tdj2hjFi0Yeoy0GyVE5OaeY+k55oCOTOZ2o_Diq5+g@mail.gmail.com>
References: <CAJxTCxyUtQuESS+Nk3+HRwjirZrs9A6Ypis=XfPcVV0=siJ0Qg@mail.gmail.com>
<CANzqJaD5tdj2hjFi0Yeoy0GyVE5OaeY+k55oCOTOZ2o_Diq5+g@mail.gmail.com>
Le dim. 10 mai 2026 à 04:51, Ron Johnson <ronljohnsonjr@gmail.com> a écrit :
> On Sat, May 9, 2026 at 5:49 AM Jérémy 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
>> this
>> Clé 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=# SELECT
schemaname, tablename, attname, inherited, n_distinct, most_common_vals
FROM pg_stats WHERE tablename = 'mytable' AND attname = '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érémy
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: kapouer@melix.org, pgsql-general@lists.postgresql.org
Subject: Re: fdw: foreign partition and aggregate function
In-Reply-To: <CAJxTCxw6X4G8wpW-41Md0sf5pn=aVCLXC9=H71v_xLa5_xnGPA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox