public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
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 <[email protected]> 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: [email protected]
Cc: [email protected], [email protected]
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