| From: | Sbob <sbob(at)quadratum-braccas(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Local parent table and Foreign table(s) as partition(s), is it possible? |
| Date: | 2022-09-14 18:17:34 |
| Message-ID: | 7e2b6998-d62c-0460-066d-dce9f238e5af@quadratum-braccas.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 9/14/22 12:01, Laurenz Albe wrote:
> 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
Nice! so do I simply use the INHERITS clause or the PARTITION OF clause
when I create the foreign table and reference the local parent table?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sylvain Deveaux | 2022-09-14 23:31:43 | Ldap config for Active Directory |
| Previous Message | Laurenz Albe | 2022-09-14 18:01:11 | Re: Local parent table and Foreign table(s) as partition(s), is it possible? |