Re: Multiple Tablespaces with single mount point?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Multiple Tablespaces with single mount point?
Дата
Msg-id CAKFQuwaLvhPq4yHckxT5Mmmn3uvT3KadA9h8NHS_aJsCnoZTNg@mail.gmail.com
обсуждение исходный текст
Ответ на Multiple Tablespaces with single mount point?  (Curious Tech <cutech777@gmail.com>)
Ответы Re: Multiple Tablespaces with single mount point?
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Curious Tech
Дата:
Сообщение: Multiple Tablespaces with single mount point?
Следующее
От: Curious Tech
Дата:
Сообщение: Re: Multiple Tablespaces with single mount point?