recommended way of separating data from indexes - Mailing list pgsql-general

From Anton Melser
Subject recommended way of separating data from indexes
Date
Msg-id 92d3a4950805160003lb5195cdnf26ac52e84c2b6ed@mail.gmail.com
Whole thread Raw
Responses Re: recommended way of separating data from indexes  (Richard Huxton <dev@archonet.com>)
List 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 by date:

Previous
From: Ottavio Campana
Date:
Subject: Re: problem with serial data type and access
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"