Re: test_fsync open_sync test

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: test_fsync open_sync test
Date: 2011-01-18 01:29:13
Message-ID: 4D34ECE9.6010407@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian wrote:
> Is there a value to this test_fsync test?
>
> Compare open_sync with different sizes:
> (This is designed to compare the cost of one large
> sync'ed write and two smaller sync'ed writes.)
> open_sync 16k write 242.563 ops/sec
> 2 open_sync 8k writes 752.752 ops/sec
>
> It compares the cost of doing larger vs. two smaller open_sync writes.
>

Might be some value for determining things like what the optimal WAL
block size to use is. All these tests are kind of hard to use
effectively still, I'm not sure if it's time to start trimming tests yet
until we've made more progress on interpreting results first.

--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Smith 2011-01-18 01:42:45 Re: Moving test_fsync to /contrib?
Previous Message Dan Ports 2011-01-18 01:26:11 Re: SSI patch version 12