> i have a question about best harddisk configuration for postgresql
> of course i know that:
> - scsi is better than ide
> - 2 disks are better than 1
> - 3 disks are better than 2
> i know that with 3 disks one should move xlog to one drive, index files
> to second and tables to third.
> that's clear.
Er, no, it's not. In fact, for a 3-disk config, I reccommend:
Disk 1: OS, swap, system logs
Disk 2: Data + Indexes
Disk 3: Transaction Log
> will making software raid on this discs provide performance increase or
Hardware RAID can improve *read* performance, particilarly RAIDs 1, 01, and
10. For writing, the best you can do is having it not inhibit performance.
The general testament is that *software* RAID does not improve things at all;
actually, the best that can be said for Linux Software RAID 1 is that it does
not harm performance much.
> i'd like to know what are the options to store all this information
> (xlog, indices and tables). what configurations are best, what medium
> and what should be avoided at all cost.
Ask specific questions. If you want the full performance tutorial, you'd have
to pay a steep fee for 1-3 days of training.
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Keith Bottner||Date: 2002-12-09 20:00:32|
|Subject: Re: questions about disk configurations|
|Previous:||From: Bruce Momjian||Date: 2002-12-09 18:09:31|
|Subject: Re: Speeding up aggregates|