Re: [PERFORM] Adding disks/xlog & index

2007-05-25 Thread Gregory Stark
<[EMAIL PROTECTED]> writes: > Some questions on this: > 1. Can the database survive loss/corruption of the xlog and indexes in a > recoverable way? To save money (and because I won't need the throughput as > much), I am thinking on making this index/wal/xlog drive a single cheap > sata drive (or m

Re: [PERFORM] Adding disks/xlog & index

2007-05-25 Thread Tom Lane
[EMAIL PROTECTED] writes: > The best one I have come up with is moving the xlog/wal (can someone > confirm whether these are the same thing?) to another physical drive. Yeah, two names for same thing. > I also think it may be beneficial to move some indexes to another drive as > well (same one as

Re: [PERFORM] Adding disks/xlog & index

2007-05-25 Thread Tom Lane
[EMAIL PROTECTED] writes: > The best one I have come up with is moving the xlog/wal (can someone > confirm whether these are the same thing?) to another physical drive. Yeah, two names for same thing. > I also think it may be beneficial to move some indexes to another drive as > well (same one as

[PERFORM] Adding disks/xlog & index

2007-05-25 Thread lists
I have a busy postgresql server running running on a raid1 of 2 15k rpm scsi drives. I have been running into the problem of maxed out IO bandwidth. I would like to convert my raid1 into a raid10 but that would require a full rebuild which is more downtime than I want so I am looking into other al