Re: further testing on IDE drives - Mailing list pgsql-performance

From scott.marlowe
Subject Re: further testing on IDE drives
Date
Msg-id Pine.LNX.4.33.0310101200260.19272-100000@css120.ihs.com
Whole thread Raw
In response to Re: further testing on IDE drives  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
On Fri, 10 Oct 2003, Josh Berkus wrote:

> Bruce,
>
> > Yes.  If you were doing multiple WAL writes before transaction fsync,
> > you would be fsyncing every write, rather than doing two writes and
> > fsync'ing them both.  I wonder if larger transactions would find
> > open_sync slower?
>
> Want me to test?   I've got an ide-based test machine here, and the TPCC
> databases.

Just make sure the drive's write cache is disabled.


pgsql-performance by date:

Previous
From: Nick Barr
Date:
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Next
From: Dror Matalon
Date:
Subject: Re: Speeding up Aggregates