From: William Yu <wyu@talisys.com>
To: pgsql-performance@postgresql.org
Subject: Re: Some Performance Advice Needed
Date: Thu, 23 Dec 2004 13:45:57 -0800
Message-ID: <cqfecl$2bmm$1@news.hub.org> (raw)
In-Reply-To: <41CB3830.2090201@commandprompt.com>
References: <41CAD5C3.6090404@meerkatsoft.com>
<27CB29DA-54F1-11D9-9712-000D9366F0C4@torgo.978.org>
<41CB3830.2090201@commandprompt.com>
>> 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.
From my experience with SATA controllers, write caching is controlled
via the BIOS.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: wyu@talisys.com
Subject: Re: Some Performance Advice Needed
In-Reply-To: <cqfecl$2bmm$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox