Re: [GENERAL] recommended way of separating data from indexes

2008-05-16 Thread Richard Huxton
Anton Melser wrote: It's a website, with probably around 98% read to 2% write, and the writes only to a few tables. The machine is only doing this one DB, with the odd email being sent by postfix (20 p/d, so nothing) and for the moment we aren't doing any real logging apart from postgres inte

Re: [GENERAL] recommended way of separating data from indexes

2008-05-16 Thread Anton Melser
Hi, >> 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.

Re: [GENERAL] recommended way of separating data from indexes

2008-05-16 Thread Richard Huxton
Anton Melser wrote: 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 s

[GENERAL] recommended way of separating data from indexes

2008-05-16 Thread Anton Melser
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 us