Date: Tue, 29 Jan 2008 10:46:47 +0100 From: "Claus Guttesen" <kometen@gmail.com> To: "Ivan Voras" <ivoras@freebsd.org> Cc: freebsd-performance@freebsd.org Subject: Re: postgresql-performance using sysbench Message-ID: <b41c75520801290146g4e6e2c17oe2fc432245253ba7@mail.gmail.com> In-Reply-To: <fnmrri$pi4$1@ger.gmane.org> References: <b41c75520801280701x35e628dk90841b55cac77045@mail.gmail.com> <fnl35p$hnj$1@ger.gmane.org> <200801281024.11571.darcyb@commandprompt.com> <b41c75520801281221i5fbb32f3p1e2f3be40a8dfa74@mail.gmail.com> <479E3C5E.1070405@FreeBSD.org> <b41c75520801281246q16d305ecue915e66bea6ac5ab@mail.gmail.com> <fnmrri$pi4$1@ger.gmane.org>
next in thread | previous in thread | raw e-mail | index | archive | help
> > I forgot to mention in my first post that I'm using ULE. The p800 > > controller has a (factory set) 25/75 read/write cache ratio. > > There's maybe one additional thing: do you dual-boot Linux and FreeBSD? > If so, you'll need to set up a separate additional partition for the > database, instead of benchmarking it with the file systems used by the > OS, because different areas of the drive(s) have different performance - > you can verify this with diskinfo -t. I installed FreeBSD onto a boot-partition (p400i-controller) and used the external storage (p800) as database-partition (eight 15K rpm sas-disks in raid 1+0). Same with Ubuntu. When I re-installed FreeBSD and ubuntu I wiped and formatted the previous partitions. Ubuntu used ext3 which I guess is default fs. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?b41c75520801290146g4e6e2c17oe2fc432245253ba7>