Re: Tablespaces on a raid configuration

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Tablespaces on a raid configuration
Дата
Msg-id 4F75CB14.9060607@dunslane.net
обсуждение исходный текст
Ответ на Tablespaces on a raid configuration  ("Campbell, Lance" <lance@illinois.edu>)
Ответы Re: Tablespaces on a raid configuration  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance

On 03/30/2012 10:45 AM, Campbell, Lance wrote:
>
> PostgreSQL 9.0.x
>
> When PostgreSQL  storage is using a relatively large raid  5 or 6
> array is there any value in having your tables distributed across
> multiple tablespaces if those tablespaces will exists on the same raid
> array?  I understand the value if you were to have the tablespaces on
> different raid arrays.  But what about on the same one?
>
>

Not answering your question, but standard advice is not to use RAID 5 or
6, but RAID 10 for databases. Not sure if that still hold if you're
using SSDs.

cheers

andrew

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

Предыдущее
От: Greg Spiegelberg
Дата:
Сообщение: Re: Tablespaces on a raid configuration
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Tablespaces on a raid configuration