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@xxxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
