Re: Tablespace on Postgrsql

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: Tablespace on Postgrsql
Дата
Msg-id CAKoxK+4wgQzMG5_MZa0P9hcy3e70qsEbDQ_JHz9VuyRQcR0wvA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Tablespace on Postgrsql  (devonline <devonline@backpost.com>)
Ответы Re: Tablespace on Postgrsql  (devonline <devonline@backpost.com>)
Список pgsql-general
On Thu, Jul 25, 2013 at 2:53 AM, devonline <devonline@backpost.com> wrote:
> Our current database size is
>
> 1 Terabyte
>

The idea behind tablespaces is to gain I/O scattering data (and
therefore requests) across different devices. Therefore you have to
identify first if your database can be "scattered" across different
devices (not different partiion of the same hdd) and then decide which
parts need to get more bandwidth ajnd which can get fewer.

Luca


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

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: Re: Rule Question
Следующее
От: Some Developer
Дата:
Сообщение: Re: Why are stored procedures looked on so negatively?