Date: Sat, 12 Nov 2005 10:32:52 +0800 From: Dryice Liu <dryice@hotpop.com> To: freebsd-database@freebsd.org Subject: Re: suggested block size for a frequently updated postgresql? Message-ID: <86ek5msii3.fsf@dryice.3322.org> In-Reply-To: <200511111824.jABIO4Sh074288@lurza.secnetix.de> (Oliver Fromme's message of "Fri, 11 Nov 2005 19:24:04 %2B0100 (CET)") References: <200511111824.jABIO4Sh074288@lurza.secnetix.de>
next in thread | previous in thread | raw e-mail | index | archive | help
--=-=-= Content-Transfer-Encoding: quoted-printable Oliver Fromme <olli@lurza.secnetix.de> wrote: > Dryice Liu <dryice@hotpop.com> wrote: > > I'm planning on setting up a postgresql server, the database data > > files are on their own slice so I can tune the file system for pgsql. > >=20 > > The database is pretty large. On my test server, some data files get > > larger than 1G and is splitted by pgsql. Also the database will be > > updated frequently. > >=20 > > I'm planning on setting the slice with a bigger block size/fragment > > size but not sure if that's a good idea. I know the default on FreeBSD > > is 16K/2K, I'm planning on something like 1M/128K. > > So, the bottom line is: I recommend you leave the bsize > and fsize at the default 16K/2K. However, you probably > should reduce the inode density from the default, i.e. use > the -i option with some high value such as 262144 (that's > 2^18). But don't make this value too high either ... > I remember someone tried to set it to 64 million or some- > thing, which broke his FS. Thanks for the detail explanation and suggestion! =2D-=20 Dryice @ http://dryice.3322.org Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/sylvester-response.html --=-=-= Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (FreeBSD) iD8DBQBDdVSZa1t4qHe2eHQRAsy2AJ4hY0TgXjeO5tLQZERgnBtbBGuqQgCfT5+M RWfSgzQ6PhAdhJOS5rR8xog= =IH8u -----END PGP SIGNATURE----- --=-=-=--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?86ek5msii3.fsf>