Re: Multiple Tablespaces with single mount point?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Curious Tech <cutech777(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Multiple Tablespaces with single mount point?
Date: 2016-08-12 21:07:24
Message-ID: CAKFQuwaLvhPq4yHckxT5Mmmn3uvT3KadA9h8NHS_aJsCnoZTNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Aug 12, 2016 at 4:59 PM, Curious Tech <cutech777(at)gmail(dot)com> wrote:

> Hello,
>
> I want to know what is the general practice when only one mount point is
> available.
>
> 1. Use default tablespace
> 2. Use Default + User Define one tablespace
> 3. Use Default + User Defined Data + User Defined Index tablespaces
>
>
1.

Using non-default tablespace adds backup/restore complications. Don't do
that without a demonstrable benefit. You will not be able to demonstrate a
benefit when you only have a single filesystem.

David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Curious Tech 2016-08-12 21:14:28 Re: Multiple Tablespaces with single mount point?
Previous Message Curious Tech 2016-08-12 20:59:30 Multiple Tablespaces with single mount point?