Re: full_page_writes = off?

From: Martin Marques <martin(at)marquesminen(dot)com(dot)ar>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: full_page_writes = off?
Date: 2007-12-03 12:15:59
Message-ID: 4753F37F.6050105@marquesminen.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

Greg Smith escribió:
> On Sat, 1 Dec 2007, Tomasz Ostrowski wrote:
>
>> You can also use "hdparm -I" to check this - look for a "Write
>> caching" in "Commands/features" section. If it has a "*" in front
>> then it is enabled and dangerous.
>
> Right; using -I works with most Linux hdparm versions:
>
> # hdparm -V
> hdparm v6.6
> # hdparm -I /dev/hda | grep "Write cache"
> * Write cache
> # hdparm -W 0 /dev/hda
>
> /dev/hda:
> setting drive write-caching to 0 (off)
> # hdparm -I /dev/hda | grep "Write cache"
> Write cache

Out of ignorance, do RAID[1] devices have write cache?

[1]: I'm talking about RAID through hardware.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Greg Smith 2007-12-03 14:04:31 Re: full_page_writes = off?
Previous Message Tom Lane 2007-12-03 03:08:57 Re: About contrib modules

Browse pgsql-general by date

  From Date Subject
Next Message Dragan Zubac 2007-12-03 12:16:02 Re: [HACKERS] Stored procedure issue
Previous Message Norberto Delle 2007-12-03 11:31:01 Re: Dump/Restore Large Object OID