| From: | Jeff <threshar(at)torgo(dot)978(dot)org> |
|---|---|
| To: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
| Cc: | pgsql-general(at)postgresql(dot)org, shridhar_daithankar(at)persistent(dot)co(dot)in |
| Subject: | Re: ATA disks and RAID controllers for database servers |
| Date: | 2003-11-15 14:44:51 |
| Message-ID: | 20031115094451.6cf95631.threshar@torgo.978.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, 15 Nov 2003 14:07:40 +1300
Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> wrote:
>
> Clearly it is possible to obtain very good performance with write
> caching on using RAID0, and if you have a UPS together with good backup
> practice then this could be the way to go.
>
> With caching off there is a considerable decrease in performance,
> however this performance may be "good enough" if viewed in a
> cost-benefit-safely manner.
>
>
UNless the controller itself has a battery backed cache it is dangerous - there are many more failures than losing power. Ie, blowing out the power supply or cpu. We've burnt up a fair share of cpu's over the years. Luckly on a Sun it isn't that big a deal.. but on x86. wel... you get the idea.
--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michal Zaborowski | 2003-11-15 15:05:57 | Re: embedded postgresql + C++ IDE |
| Previous Message | fuzzy | 2003-11-15 13:33:27 | Re: Can Postgresql run under Windows? |