Re: full_page_writes = off?

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

Tomasz Ostrowski escribió:
> On Sat, 01 Dec 2007, rihad wrote:
>
>> fsync = on;
>> synchronous_commit = off;
>> full_page_writes = off;
>> Thanks for any insights or clarifying missed points.
>
> 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

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tomasz Ostrowski 2007-12-01 12:16:01 Re: full_page_writes = off?
Previous Message Tomasz Ostrowski 2007-12-01 11:47:57 Re: full_page_writes = off?

Browse pgsql-general by date

  From Date Subject
Next Message Tomasz Ostrowski 2007-12-01 12:16:01 Re: full_page_writes = off?
Previous Message Tomasz Ostrowski 2007-12-01 11:47:57 Re: full_page_writes = off?