Re: Offline Tablespaces and Partial Restore

On 1/11/16 8:41 AM, Pedro França wrote:
> I've tried to put the data on another database but it didn't help as
> tablespaces are required cluster-wide on startup.

If putting the data in a separate database works for you then it
wouldn't be a big leap to put it in a separate cluster.
Functionality-wise it's pretty similar since you can't join across
databases in Postgres.

There are some advantages to this design since you can separate the
buffer caches, tune optimizer variables, wal settings, etc.

--
-David
david@pgmasters.net