| From: | Jeff <threshar(at)torgo(dot)978(dot)org> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org, Alex <alex(at)meerkatsoft(dot)com> |
| Subject: | Re: Some Performance Advice Needed |
| Date: | 2004-12-27 13:46:28 |
| Message-ID: | B59DACCE-580D-11D9-830A-000D9366F0C4@torgo.978.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Dec 23, 2004, at 4:27 PM, Joshua D. Drake wrote:
>>
>> IDE disks lie about write completion (This can be disabled on some
>> drives) whereas SCSI drives wait for the data to actually be written
>> before they report success. It is quite
>> easy to corrupt a PG (Or most any db really) on an IDE drive. Check
>> the archives for more info.
>
> Do we have any real info on this? Specifically which drives? Is SATA
> the same way? What about SATA-II?
> I am not saying it isn't true (I know it is) but this is a blanket
> statement that may or may not be
> true with newer tech.
Scott Marlowe did some tests a while ago on it. They are likely in the
archives.
Maybe we can get him to pipe up :)
--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sarlav kumar | 2004-12-27 17:32:33 | user defined data type problem while dumping? |
| Previous Message | Cosimo Streppone | 2004-12-27 11:36:50 | Re: Howto Increased performace ? |