Re: Can we have multiple tablespaces with in a database.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Can we have multiple tablespaces with in a database.
Дата
Msg-id CAKFQuwbcjgX8h7X=aSdxfMaGi1T2wYpyM4U1ZktS2eBcz9R7xA@mail.gmail.com
обсуждение исходный текст
Ответ на Can we have multiple tablespaces with in a database.  (Daulat Ram <Daulat.Ram@exponential.com>)
Ответы Re: Can we have multiple tablespaces with in a database.  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
Please pick a single list to post to.  Performance seems like the unnecessary one here.

On Thu, Feb 20, 2020 at 10:34 PM Daulat Ram <Daulat.Ram@exponential.com> wrote:

Can we have multiple tablespaces with in a database in postgres?


I fell as if I'm missing something in your question given the presence of the "CREATE TABLESPACE" SQL command and the related non-command documentation covered here:

 

Can we have a table on different tablespace same as Oracle?


There is no provision to assign two tablespaces to a single physical table.  To the benefit of those who don't use the other product you may wish to say exactly what you want to do instead of comparing it to something that many people likely have never used.

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: amul sul
Дата:
Сообщение: Re: Can we have multiple tablespaces with in a database.
Следующее
От: Ron
Дата:
Сообщение: Re: Can we have multiple tablespaces with in a database.