[PERFORM] IDE/SCSI disk tools to turn off write caching

2004-01-15 Thread Syd
We've found these tools http://scsirastools.sourceforge.net/ and http://www.seagate.com/support/seatools/ (for seagate drives) to check the settings of scsi disks and to change settings for seagate drives. What are people using for IDE disks? Are you all using hdparm on linux http://freshmeat.net

Re: [PERFORM] insert speed - Mac OSX vs Redhat

2004-01-15 Thread Syd
On 16/01/2004, at 2:44 AM, Tom Lane wrote: ... As noted elsewhere, it's highly likely that this has nothing to do with the OS, and everything to do with write caching in the disks being used. I assume you are benchmarking small individual transactions (one insert per xact). In such scenarios it'

[PERFORM] insert speed - Mac OSX vs Redhat

2004-01-15 Thread Syd
I've read most of the threads on insert speed in this list and wanted to share some interesting observations and a question. We've been benchmarking some dbs to implement Bayesian processing on an email server. This involves frequent insert and updates to the following table: create table baye