Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 28 Aug 2003 15:51:45 -0700
From:      Sean Chittenden <sean@chittenden.org>
To:        Claus Guttesen <cguttesen@yahoo.dk>
Cc:        freebsd-database@freebsd.org
Subject:   Re: Some additional tests run on my performance testing
Message-ID:  <20030828225145.GS83759@perrin.nxad.com>
In-Reply-To: <20030828204032.97741.qmail@web14102.mail.yahoo.com>
References:  <20030828171955.GE83759@perrin.nxad.com> <20030828204032.97741.qmail@web14102.mail.yahoo.com>

next in thread | previous in thread | raw e-mail | index | archive | help
> 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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030828225145.GS83759>