Re: SCSI vs SATA - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: SCSI vs SATA
Date
Msg-id 4613C6F1.3090009@commandprompt.com
Whole thread Raw
In response to Re: SCSI vs SATA  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Responses Re: SCSI vs SATA  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-performance
>> SATAII brute forces itself through some of its performance, for
>> example 16MB write cache on each drive.
>
> sure but for any serious usage one either wants to disable that
> cache(and rely on tagged command queuing or how that is called in SATAII

Why? Assuming we have a BBU, why would you turn off the cache?

> world) or rely on the OS/raidcontroller implementing some sort of
> FUA/write barrier feature(which linux for example only does in pretty
> recent kernels)

Sincerely,

Joshua D. Drake

>
>
> Stefan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>


--

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


pgsql-performance by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: SCSI vs SATA
Next
From: Andreas Kostyrka
Date:
Subject: Re: SCSI vs SATA