Re: Bgwriter behavior - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Bgwriter behavior
Date
Msg-id 1104265210.6459.10.camel@localhost.localdomain
Whole thread Raw
In response to Re: Bgwriter behavior  (John Hansen <john@geeknet.com.au>)
List pgsql-hackers
On Tue, 2004-12-28 at 07:23, 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
> > 
> > The tests were on a machine with a single SCSI drive that doesn't lie
> > about fsync.  I found 7.4.X got around 75tps while 8.0 got 100tps, very
> > similar to the 65/107 numbers Tom had.
> 
> You do realize, that pgbench result comparisons are about as useful as a
> fork for eating soup?

I'd have to agree. I find it hard to get comparable results on my test
server, let alone discuss other people's findings.

The only tests I have reasonable faith in these days are those performed
to a rigorous test method, which is also published, visible and
challengeable. OSDL is the nearest thing to that we have to that.

-- 
Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Windows default to localhost is in the wrong place
Next
From: Andrew Dunstan
Date:
Subject: buildfarm NetBSD/m68k tsearch regression failure