Re: full_page_writes = off? - Mailing list pgsql-general

From Tomasz Ostrowski
Subject Re: full_page_writes = off?
Date
Msg-id 20071201121601.GB2552@batory.org.pl
Whole thread Raw
In response to Re: full_page_writes = off?  (Martin Marques <martin@marquesminen.com.ar>)
Responses Re: full_page_writes = off?
List pgsql-general
On Sat, 01 Dec 2007, Martin Marques wrote:

>> Also check whether a disks have write-caching turned off - it should.
>> On Linux the command is:
>>     # hdparm -W /dev/sda
>>     /dev/sda:
>>      write-caching =  0 (off)
>
> Uh? That command as was written lacks an argument for -W (0/1). From the
> hdparm --help:
>
>  -W   set drive write-caching flag (0/1) (DANGEROUS)
>
> # hdparm -V
> hdparm v6.9

# hdparm -V
hdparm v7.7
# hdparm --help 2>&1 | grep write-caching
 -W   get/set drive write-caching flag (0/1)

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.

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
                                                      Winnie the Pooh

pgsql-general by date:

Previous
From: Martin Marques
Date:
Subject: Re: full_page_writes = off?
Next
From: Pascal Cohen
Date:
Subject: Re: HA and Replication - how to choose among all the available solutions