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 [email protected] Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
