Right now my dbs are hosted by Heroku, so I doubt I have any control over
the dbs at that level.
Thanks for the idea though! :)
On Wed, Mar 25, 2020 at 12:04 PM Michael Lewis wrote:
> Chris,
> Does it actually need to be a different server and database, or would it
> be possible to have
Chris,
Does it actually need to be a different server and database, or would it be
possible to have another storage device added to your existing database and
make use of tablespaces to accomplish pseudo-archive of older partitions?
Just a thought.
>
>
> Not yet.. There is ongoing work to make that happen though.
Glad to hear it. :) Thx.
Greetings,
* Laurenz Albe (laurenz.a...@cybertec.at) wrote:
> On Tue, 2020-03-24 at 17:50 -0500, Chris Morris wrote:
> > 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.
>
> > 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
On Tue, 2020-03-24 at 17:50 -0500, Chris Morris wrote:
> 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.
Yours,
Laurenz
