Re: full_page_writes = off?

From: Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl>
To: Martin Marques <martin(at)marquesminen(dot)com(dot)ar>
Cc: rihad(at)mail(dot)ru, pgsql-general(at)postgresql(dot)org
Subject: Re: full_page_writes = off?
Date: 2007-12-01 12:16:01
Message-ID: 20071201121601.GB2552@batory.org.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs 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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Albert Cervera i Areny 2007-12-02 17:34:17 Re: About contrib modules
Previous Message Martin Marques 2007-12-01 12:04:44 Re: full_page_writes = off?

Browse pgsql-general by date

  From Date Subject
Next Message Pascal Cohen 2007-12-01 14:02:33 Re: HA and Replication - how to choose among all the available solutions
Previous Message Martin Marques 2007-12-01 12:04:44 Re: full_page_writes = off?