| 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 18:04:54 |
| Message-ID: | 200412281804.iBSI4s202438@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
> >
> > 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?
>
> On another note, how do you know for sure, that your drive does not lie
> about fsync?
>
> Did you run the tests with fsync turned off vs fsync on?
I just tried and got 115tps with fsync off vs 100 with fsync on, so
fsync is certainly doing something.
--
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-12-28 18:10:11 | Re: Bgwriter behavior |
| Previous Message | Andrew Dunstan | 2004-12-28 17:05:36 | Re: Multiple language support |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-12-28 18:10:11 | Re: Bgwriter behavior |
| Previous Message | John Hansen | 2004-12-28 07:23:50 | Re: Bgwriter behavior |