Re: Some additional tests run on my performance testing
From: David Schultz (das_at_FreeBSD.ORG)
Date: 08/29/03
- Previous message: Bill Moran: "Taking another shot at the PostgreSQL/filesystem benchmarks"
- In reply to: Claus Guttesen: "Re: Some additional tests run on my performance testing"
- Next in thread: Bruce Evans: "Re: Some additional tests run on my performance testing"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 28 Aug 2003 18:22:17 -0700 To: Claus Guttesen <cguttesen@yahoo.dk>
On Thu, Aug 28, 2003, Claus Guttesen wrote:
> So I newfs'ed it with 8 and 16 kb blocksize did an
> import of a 1.5 GB pg-dump.
>
> > numbers you suggest above, I loaded a DB with 8k and
> > 16K blocks
> > (translation: almost all write activities).
> >
> > them to stay about the same across the board. If
> > someone wants to do
> > some good read tests, I'd be interested in those
> > results.
> >
>
> The 8 kb blocksize took 60 min. to import, and the 16
> kb ditto took 45 min. So I'm settling on 16 kb blocks.
Note that doing sequential reads and writes is VERY different from
doing random reads and writes. In the former case, a larger
filesystem block size may reduce fragmentation and help you, but
in the latter case---specifically for writes---you're doing twice
the I/O due to the larger filesystem blocks. Your import and
Bill's tests fall into the first category. It would be
interesting to see what sort of performance you get under a real
workload.
_______________________________________________
freebsd-performance@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@freebsd.org"
- Previous message: Bill Moran: "Taking another shot at the PostgreSQL/filesystem benchmarks"
- In reply to: Claus Guttesen: "Re: Some additional tests run on my performance testing"
- Next in thread: Bruce Evans: "Re: Some additional tests run on my performance testing"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]