| From: | "Anton Melser" <melser(dot)anton(at)gmail(dot)com> |
|---|---|
| To: | "Postgres General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | recommended way of separating data from indexes |
| Date: | 2008-05-16 07:03:17 |
| Message-ID: | 92d3a4950805160003lb5195cdnf26ac52e84c2b6ed@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 ...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2008-05-16 07:06:11 | Postgresql MVCC, Read Committed Isolation Level and taking "snapshot" |
| Previous Message | Ottavio Campana | 2008-05-16 06:44:34 | Re: problem with serial data type and access |