Re: What is the general opinion on use of tablespaces

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Rakesh Kumar <rakeshkumar464a3(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: What is the general opinion on use of tablespaces
Date: 2016-06-10 16:46:29
Message-ID: CAKFQuwZBU0jBrHToWGeG_7OK8ozQGR+1NLDKALe5H=xVtA7MrQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 10, 2016 at 12:26 PM, Rakesh Kumar <rakeshkumar464a3(at)gmail(dot)com>
wrote:

> I saw a slide recently where the use of tablespaces was discouraged.
> What does the community think of tablespaces.
>

They are a tool and their use should neither be encouraged nor discouraged
but rather understood and used when appropriate.

​Their main problem to overcome when using them is that they tie PostgreSQL
much more tightly to the underlying configuration of the operating system
and thus you need to ensure that your processes and procedures accommodate
that reality since the ​tools that PostgreSQL provides can only do so much.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2016-06-10 16:47:29 Re: [pg_trgm] Making similarity(?, ?) < ? use an index
Previous Message Dan Wierenga 2016-06-10 16:43:29 Re: [HACKERS] Online DW