On Fri, 24 Oct 2003, Scott Chapman wrote:
> On Friday 24 October 2003 16:23, scott.marlowe wrote:
> > Right, but NONE of the benchmarks I've seen have been with IDE drives with
> > their cache disabled, which is the only way to make them reliable under
> > postgresql should something bad happen. but thanks for the benchmarks,
> > I'll look them over.
>
> I don't recall seeing anyone explain how to disable caching on a drive in this
> thread. Did I miss that? 'Would be useful. I'm running a 3Ware mirror of 2
> IDE drives.
>
> Scott
Each OS has it's own methods, and some IDE RAID cards don't give you
direct access to the drives to enable / disable write cache.
On Linux you can disable write cache like so:
hdparm -W0 /dev/hda
back on:
hdparm -W1 /dev/hda
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
