On Tue, Feb 21, 2017 at 2:37 PM, Andres Freund <and...@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. > +1 ------ Alexander Korotkov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
