Re: table spaces

Поиск
Список
Период
Сортировка
От Gregg Jaskiewicz
Тема Re: table spaces
Дата
Msg-id CAJY59_hiGizAWnc8E7RGyYb7phN3n7m10Xo3S00QbTk5Wzpr6A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: table spaces  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: table spaces
Re: table spaces
Список pgsql-general
Ok, 

So by that token (more drives the better), I should have raid 5 (or whichever will work) with all 6 drives in it ?

I was thinking about splitting it up like this. I have 6 drives (and one spare). Combine them into 3 separate logical drives in mirrored configuration (for some hardware redundancy). 
And use one for base system, and some less frequently read tables, second one for WAL, third one for whatever tables/indexes happen to need separate space (subject to characterisation outcome). 

I was basically under impression that separating WAL is a big plus. On top of that, having separate partition to hold some other data - will do too. 
But it sounds - from what you said - like having all in single logical drive will work, because raid card will spread the load amongst number of drives. 
Am I understanding that correctly ?


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

Предыдущее
От: "Emre Hasegeli"
Дата:
Сообщение: Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks
Следующее
От: Erik Jones
Дата:
Сообщение: Age of the WAL?