Advantage of more than 1 tablespace on 1 disk?

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Advantage of more than 1 tablespace on 1 disk?
Дата
Msg-id bddc86150811030236o169542eck8e476d2a561612d3@mail.gmail.com
обсуждение исходный текст
Ответы Re: Advantage of more than 1 tablespace on 1 disk?  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
Re: Advantage of more than 1 tablespace on 1 disk?  (Rainer Pruy <Rainer.Pruy@Acrys.COM>)
Список pgsql-general
Hi,

I've got a database with massive tables which fall into 2 categories:
Tables which don't change often but get read a LOT, and tables which
are heavily added to continuously and sometimes read.

Would there be any advantage in moving the latter logging tables to a
separate tablespace, bearing in mind it would still be on the same
disk?  Or have I kinda missed how tablespaces work?

Thanks

Thom

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Are there plans to add data compression feature to postgresql?
Следующее
От: "Grzegorz Jaśkiewicz"
Дата:
Сообщение: Re: Advantage of more than 1 tablespace on 1 disk?