On Tue, Feb 21, 2017 at 5:52 PM, Alexander Korotkov <a.korot...@postgrespro.ru> wrote: > 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
okay, understood. Will take care of it when I start with next round of testing. Thanks. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
