Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: [GENERAL] full_page_writes = off?


  • From: Greg Smith <gsmith(at)gregsmith(dot)com>
  • To: Bruce Momjian <bruce(at)momjian(dot)us>
  • Cc: PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
  • Subject: Re: [GENERAL] full_page_writes = off?
  • Date: Mon, 10 Dec 2007 09:27:31 -0500 (EST)
  • Message-id: <Pine(dot)GSO(dot)4(dot)64(dot)0712100918320(dot)14895(at)westnet(dot)com>

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 <productname>Linux</> use
!    <command>hdparm -I</>;  it is enabled if there is a <literal>*</> next
!    to <literal>Write cache</>.  <command>hdparm -W</> can to turn off
!    write caching.  On <productname>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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group