Re: [HACKERS] Add accurate option to pgbench

2013-11-02 Thread Tom Lane
Fabien COELHO writes: > However I think that part of this interesting checklist and discussion > could make it to some "caveat" section about reproducible performance > measures in pgbench documentation, though? +1. There's already a section of advice about how to get reproducible numbers from

Re: [HACKERS] Add accurate option to pgbench

2013-11-02 Thread Fabien COELHO
Logic of this option is under following. 1. execute cluster command to sort records. 2. execute checkpoint to clear dirty-buffers in shared_buffers. 3. execute sync command to clear dirty-file-caches in OS. 4. waiting 10 seconds for raid cache is until empty . 5. execute checkpoint to

Re: [HACKERS] Add accurate option to pgbench

2013-10-31 Thread Robert Haas
On Thu, Oct 31, 2013 at 6:36 AM, Mitsumasa KONDO wrote: > Hi, > > I create pgbench patch that adding accurate option in benchmark, and submit > it in CF3. > It is simple option to get more accurate benchmark result and to avoid miss > benchmark result in pgbench. > > Logic of this option is under

[HACKERS] Add accurate option to pgbench

2013-10-31 Thread Mitsumasa KONDO
Hi, I create pgbench patch that adding accurate option in benchmark, and submit it in CF3. It is simple option to get more accurate benchmark result and to avoid miss benchmark result in pgbench. Logic of this option is under following. 1. execute cluster command to sort records. 2. execute c