From: Martin Marques <martin@marquesminen.com.ar>
To: Tomasz Ostrowski <tometzky@batory.org.pl>
Cc: rihad@mail.ru
Cc: pgsql-general@postgresql.org
Subject: Re: full_page_writes = off?
Date: Sat, 01 Dec 2007 09:04:44 -0300
Message-ID: <47514DDC.70607@marquesminen.com.ar> (raw)
In-Reply-To: <20071201114754.GA2552@batory.org.pl>
References: <4751150F.8080604@mail.ru>
<20071201114754.GA2552@batory.org.pl>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: martin@marquesminen.com.ar, tometzky@batory.org.pl, rihad@mail.ru, pgsql-general@postgresql.org
Subject: Re: full_page_writes = off?
In-Reply-To: <47514DDC.70607@marquesminen.com.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox