On Tue, Feb 21, 2017 at 2:37 PM, Andres Freund <andres@anarazel.de> wrote:
On 2017-02-21 16:57:36 +0530, Ashutosh Sharma wrote: > Yes, there is still some regression however it has come down by a > small margin. I am not doing initdb for each run instead I am doing, > dropdb-->createdb-->pgbench -i. Is dropping old database and creating > a new one for every run not okay, Do I have to do initdb every time. > Okay, I can change the order of reading and let you know the results.
That does make a difference. Primarily because WAL writes in a new cluster are a more expensive than in an old one, because of segment recycling.