Re: [HACKERS] pg_test_fsync output and commit_delay

2012-09-08 Thread Josh Berkus
> The attached simple patch alters the output produced by pg_test_fsync, > so that we also see the average sync time per op. Good idea. A median would be even better, but harder to calculate, I imagine. You might consider providing a maximum, too. > The pg_test_fsync > docs have had minor alt

[HACKERS] pg_test_fsync output and commit_delay

2012-09-08 Thread Peter Geoghegan
I propose that we try and develop better commit_delay advice, to make it easier to set the parameter in a way that actually helps performance. I have been researching a way to make commit_delay adaptive, though have yet to develop any further insight that is worth sharing. This may change. The att