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

From Josh Berkus
Subject Re: further testing on IDE drives
Date
Msg-id 200310101044.21177.josh@agliodbs.com
Whole thread Raw
In response to Re: further testing on IDE drives  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: further testing on IDE drives  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: further testing on IDE drives  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: further testing on IDE drives  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-performance
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.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: One or more processor ?
Next
From: Nick Barr
Date:
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL