| From: | Chris Morris <chris(at)mysteryscience(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PG 12: Partitioning across a FDW? |
| Date: | 2020-03-25 15:50:26 |
| Message-ID: | CALrUc2Xkq3T9AsBudZojwkOeGH3Q0RHcSoZuA+V0b_ndnEff1g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>
> > Is it even possible to use PG partitioning across a Foreign Server?
> I am not certain what you mean, but you can have foreign tables as
> partitions
> of a partitioned table. The partitions won't be processed in parallel
> though.
I have a large, growing table, that I'd like to start partitioning, but
also would like "older" partitions to be stored in a separate database,
connected via FDW. I haven't played around with partitioning at all yet, so
clearly I'm not sure how to ask the question :)
The hope is to still have one "seamless" table users can query, but to
spread the storage across different databases. I realize that may be asking
for too much.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2020-03-25 15:53:48 | Re: PG 12: Partitioning across a FDW? |
| Previous Message | Marius Andreiana | 2020-03-25 15:46:27 | Re: PostgreSQL 13: native JavaScript Procedural Language support ? |