On Wed, 2022-09-14 at 12:17 -0600, Sbob wrote: > > 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. > > 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? Precisely. Use declarative partitioning rather than inheritance. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
