>> To emphasize potential bad effects without having to build too large a host
>> and involve too many table spaces, I would suggest to reduce significantly
>> the "checkpoint_flush_after" setting while running these tests.
>
> Meh, that completely distorts the test.
Yep, I agree.
The point would be to show whether there is a significant impact, or not,
with less hardware & cost involved in the test.
Now if you can put 16 disks with 16 table spaces with 16 buffers per
bucket, that is good, fine with me! I'm just trying to point out that you
could probably get comparable relative results with 4 disks, 4 tables
spaces and 4 buffers per bucket, so it is an alternative and less
expensive testing strategy.
This just shows that I usually work on a tight (negligeable?) budget:-)
--
Fabien.