Postgres Pro
Downloads
Home   >   mailing lists

Re: Multiple Tablespaces with single mount point? - Mailing list pgsql-admin

From Curious Tech
Subject Re: Multiple Tablespaces with single mount point?
Date
Msg-id CAHZiM6Q8kA3ojoBj9jatyr4=_aSrWhUfo6eBoyGFPq3F6_BahA@mail.gmail.com
Whole thread Raw
In response to Re: Multiple Tablespaces with single mount point?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Multiple Tablespaces with single mount point?  (Curious Tech <cutech777@gmail.com>)
List pgsql-admin
Tree view
Thank you. I was referring to this link and that's what made me think, what if in the future scenario.


On Fri, Aug 12, 2016 at 2:07 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Fri, Aug 12, 2016 at 4:59 PM, Curious Tech <cutech777@gmail.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.


pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Multiple Tablespaces with single mount point?
Next
From: Curious Tech
Date:
Subject: Re: Multiple Tablespaces with single mount point?