"Dave Page" <dpage@vale-housing.co.uk> writes:
>> Aside from load testing as suggested by Vince, I'd be
>> interested to hear what happens when you pull the power cord
>> under load (repeatedly). This would give some evidence about
>> the robustness of the Windows filesystem and its ability to
>> emulate Unix sync semantics.
> OK, I can maybe do some testing on that next week (I'm off for a few
> days from today). Is there anything in particular I should look out for,
> or that you would want tested?
Make sure your test load includes lots of updating queries, and look for
database corruption --- bad data, duplicated rows, lost rows, that sort
of thing.
regards, tom lane