Some additional tests run on my performance testing

[Claus Guttesen]

Hi.

> 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.

Valid point you make there.

My db is up and running now with 16 kb blocks, but I'd
like to try it out with 8 kb blocks.

Can I simply do a file-copy of the database, newfs the
partition with 8 kb blocks, and copy the database back
to take advantage of the 8 kb blocksize?

Or do I have to dump, newfs, create and import the
database?

regards
Claus


Yahoo! Mail (http://dk.mail.yahoo.com) - Gratis: 6 MB lagerplads, spamfilter og virusscan