From owner-freebsd-arch Thu Nov 2 15: 1:26 2000 Delivered-To: freebsd-arch@freebsd.org Received: from earth.backplane.com (placeholder-dcat-1076843399.broadbandoffice.net [64.47.83.135]) by hub.freebsd.org (Postfix) with ESMTP id AA70837B4D7 for ; Thu, 2 Nov 2000 15:01:23 -0800 (PST) Received: (from dillon@localhost) by earth.backplane.com (8.11.1/8.9.3) id eA2N1H441744; Thu, 2 Nov 2000 15:01:17 -0800 (PST) (envelope-from dillon) Date: Thu, 2 Nov 2000 15:01:17 -0800 (PST) From: Matt Dillon Message-Id: <200011022301.eA2N1H441744@earth.backplane.com> To: Alfred Perlstein Cc: Marius Bendiksen , Randell Jesup , arch@FreeBSD.ORG Subject: Re: Like to commit my diskprep References: <200011021725.eA2HPeM38718@earth.backplane.com> <20001102132140.W20567@fw.wintelcom.net> <200011022135.eA2LZA740940@earth.backplane.com> <20001102135754.Y20567@fw.wintelcom.net> Sender: owner-freebsd-arch@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG :the problem isn't caching them, it's fsyncing them during appends :that cause additinal disk seeks. But that's not exactly a deadly :problem, just a little suboptimal. : :it's also fsyncs on newly created files that can cause problems. : :-- :-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org] This shouldn't be an issue. I don't know about Oracle, but with my database I pre-extend the file (e.g. in 1 MB increments, by writing zero's to the file rather then ftruncate()ing), and you don't have to fsync() every block when pre-extending a file. The database appends into space already allocated from the file extension and so no additional seeking occurs. -Matt To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-arch" in the body of the message