| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |