Re: fdw: foreign partition and aggregate function

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: fdw: foreign partition and aggregate function
Date: 2026-05-10 02:51:15
Message-ID: CANzqJaD5tdj2hjFi0Yeoy0GyVE5OaeY+k55oCOTOZ2o_Diq5+g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, May 9, 2026 at 5:49 AM Jérémy Lal <kapouer(at)melix(dot)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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gambhir Singh 2026-05-11 12:31:05 Alter the datatype on all tables present in the database (bigint to varchar)
Previous Message Jérémy Lal 2026-05-09 09:48:13 fdw: foreign partition and aggregate function