Skip site navigation (1) Skip section navigation (2)

Re: Bgwriter behavior

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: John Hansen <john(at)geeknet(dot)com(dot)au>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bgwriter behavior
Date: 2004-12-28 22:07:12
Message-ID: 200412282207.iBSM7Ce16200@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
John Hansen wrote:
> > > > I ran some tests last week and can report results similar on Tom's test:
> > > > 
> > > > 	pgbench -i -s 10 bench
> > > > 	pgbench -c 10 -t 10000 bench
> > > > 
> 
> don't you have to specify the scaling factor for the benchmark as well?
> as in pgbench -c 10 -t 10000 -s 10 bench ?
> 
> > I just tried and got 115tps with fsync off vs 100 with fsync on, so
> > fsync is certainly doing something.
> 
> well, I usually get results that differ by that much from run to run.
> Probably you ran in to more checkpoints on the second test.
> 
> Also, did you reinitialize the bench database with pgbench -i ?

I destroyed the database and recreated it.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-12-28 22:36:35
Subject: Re: buildfarm NetBSD/m68k tsearch regression failure
Previous:From: John HansenDate: 2004-12-28 21:58:06
Subject: Re: Bgwriter behavior

pgsql-patches by date

Next:From: Mark KirkwoodDate: 2004-12-28 23:20:25
Subject: Re: Bgwriter behavior
Previous:From: John HansenDate: 2004-12-28 21:58:06
Subject: Re: Bgwriter behavior

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group