Message-ID: <ba39412beb6b079a01fb3898a0b5e7eef01f084d.camel@cybertec.at>
Subject: Re: Local parent table and Foreign table(s) as partition(s), is it
 possible?
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Sbob <sbob@quadratum-braccas.com>, Pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Wed, 14 Sep 2022 20:01:11 +0200
In-Reply-To: <25206e71-b388-3c51-ce17-5fd0912398eb@quadratum-braccas.com>
References: <25206e71-b388-3c51-ce17-5fd0912398eb@quadratum-braccas.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/ba39412beb6b079a01fb3898a0b5e7eef01f084d.camel%40cybertec.at>
Precedence: bulk

On Wed, 2022-09-14 at 11:41 -0600, Sbob wrote:
> I see the below options in the CREATE FOREIGN TABLE, however I assume these would both connect
> to a master/parent table on the foreign server. Is it possible to have a Foreign Table that
> acts as a partition of a local parent table, via either method (INHERITS or PARTITION OF)?

Yes, exactly: a foreign table can be a partition of a local partitioned table.
This can be used to implement sharding, if the foreign data wrapper supports the "parallel append"
node introduced in PostgreSQL v14.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com