Some additional tests run on my performance testing

Sean Chittenden sean at chittenden.org
Thu Aug 28 15:51:47 PDT 2003


> I'm implementing postgresql 7.3.4 on FreeBSD 5.1, and decided to
> place the pgsql-folder on it's own partition so it was easier to
> test which blocksize to go for.
> 
> So I newfs'ed it with 8 and 16 kb blocksize did an import of a 1.5
> GB pg-dump.

Did you change the block size of PostgreSQL as well, or just of the
file system?  Could you try changing the block size of PostgreSQL so
that it matches the block size of the FS? -sc

-- 
Sean Chittenden


More information about the freebsd-database mailing list