Re: Bgwriter behavior

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: John Hansen <john(at)geeknet(dot)com(dot)au>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, 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 20:20:10
Message-ID: 1104265210.6459.10.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-12-28 21:23:37 buildfarm NetBSD/m68k tsearch regression failure
Previous Message Tom Lane 2004-12-28 19:57:09 Re: Windows default to localhost is in the wrong place

Browse pgsql-patches by date

  From Date Subject
Next Message John Hansen 2004-12-28 21:58:06 Re: Bgwriter behavior
Previous Message Bruce Momjian 2004-12-28 18:22:06 Re: Bgwriter behavior