public inbox for pgsql-general@postgresql.org
help / color / mirror / Atom feedFrom: Ron Johnson <ronljohnsonjr@gmail.com>
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: fdw: foreign partition and aggregate function
Date: Sat, 9 May 2026 22:51:15 -0400
Message-ID: <CANzqJaD5tdj2hjFi0Yeoy0GyVE5OaeY+k55oCOTOZ2o_Diq5+g@mail.gmail.com> (raw)
In-Reply-To: <CAJxTCxyUtQuESS+Nk3+HRwjirZrs9A6Ypis=XfPcVV0=siJ0Qg@mail.gmail.com>
References: <CAJxTCxyUtQuESS+Nk3+HRwjirZrs9A6Ypis=XfPcVV0=siJ0Qg@mail.gmail.com>
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.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
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: ronljohnsonjr@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: fdw: foreign partition and aggregate function
In-Reply-To: <CANzqJaD5tdj2hjFi0Yeoy0GyVE5OaeY+k55oCOTOZ2o_Diq5+g@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