recommended way of separating data from indexes

Поиск
Список
Период
Сортировка
От Anton Melser
Тема recommended way of separating data from indexes
Дата
Msg-id 92d3a4950805160003lb5195cdnf26ac52e84c2b6ed@mail.gmail.com
обсуждение исходный текст
Ответы Re: recommended way of separating data from indexes
Список pgsql-general
Hi,
I looked for quite a while but must have been looking in the wrong place...
I have a 6 disk (x146GB) system running Centos 5.1 - RAID 1 (2 disks)
and RAID 1+0 (4 disks). This seemed to be the recommended way of doing
it but I may have been looking in the wrong place. The system is
replicated using log shipping, so we have the archive command
activated.
What are the recommendations for this kind of system? The system is on
the RAID 1 disk. My idea was to separate only the data onto the RAID
1+0 and leave the logs and archive and rest on the RAID 1. Is this the
way to go? What is the recommended way of doing this? Just using
symbolic links? Help!
Cheers
Anton

--
echo '16i[q]sa[ln0=aln100%Pln100/snlbx]sbA0D4D465452snlbxq' | dc
This will help you for 99.9% of your problems ...

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

Предыдущее
От: Ottavio Campana
Дата:
Сообщение: Re: problem with serial data type and access
Следующее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"