Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DCE262E034E for ; Mon, 10 Dec 2007 10:27:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 98139-05 for ; Mon, 10 Dec 2007 10:27:30 -0400 (AST) Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id 6B3CD2E035B for ; Mon, 10 Dec 2007 10:27:38 -0400 (AST) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id lBAERVtY019689; Mon, 10 Dec 2007 09:27:31 -0500 (EST) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id lBAERVNB019685; Mon, 10 Dec 2007 09:27:31 -0500 (EST) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Mon, 10 Dec 2007 09:27:31 -0500 (EST) From: Greg Smith X-X-Sender: gsmith@westnet.com To: Bruce Momjian cc: PostgreSQL-documentation Subject: Re: [GENERAL] full_page_writes = off? In-Reply-To: <200712101406.lBAE6QU19627@momjian.us> Message-ID: References: <200712101406.lBAE6QU19627@momjian.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/41 X-Sequence-Number: 4709 On Mon, 10 Dec 2007, Bruce Momjian wrote: > exist for disk controller caches. Consumer-grade IDE drives are >! particularly likely to have write-back caches that will not survive a >! power failure. To check write caching on Linux use >! hdparm -I; it is enabled if there is a * next >! to Write cache. hdparm -W can to turn off >! write caching. On FreeBSD use I'm not where I can submit this as a patch right now, but there are two things that should get fixed in the above: --Saying "Consumer-grade IDE drives" isn't quite right; "Consumer-grade IDE and SATA drives" would correctly label the scope of the problem. --There's a typo on the next to last line here: "can to turn off". -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD