Received: from localhost (unknown [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 1A97B2E3D8A
	for <pgsql-general-postgresql.org@postgresql.org>;
	Sat,  1 Dec 2007 08:05:54 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 17921-01 for
	<pgsql-general-postgresql.org@postgresql.org>;
	Sat,  1 Dec 2007 08:05:44 -0400 (AST)
Received: from smtp-04.arnet.com.ar (smtp-04.arnet.com.ar [200.45.191.26])
	by postgresql.org (Postfix) with SMTP id BBCF02E3D89
	for <pgsql-general@postgresql.org>;
	Sat,  1 Dec 2007 08:05:47 -0400 (AST)
Received: (qmail 26842 invoked from network); 1 Dec 2007 12:05:44 -0000
Received: from unknown (HELO mail.marquesminen.com.ar) (190.225.11.104)
	by 0 with SMTP; 1 Dec 2007 12:05:44 -0000
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mail.marquesminen.com.ar (Postfix) with ESMTP id 4D4C527C27;
	Sat,  1 Dec 2007 09:05:44 -0300 (ART)
X-Virus-Scanned: amavisd-new at example.com
Received: from mail.marquesminen.com.ar ([127.0.0.1])
	by localhost (linus.marques [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id hMiXj03IcYAS; Sat,  1 Dec 2007 09:05:42 -0300 (ART)
Received: from [192.168.0.5] (dagobah.marques [192.168.0.5])
	by mail.marquesminen.com.ar (Postfix) with ESMTP id BD0F72759C;
	Sat,  1 Dec 2007 09:05:41 -0300 (ART)
Message-ID: <47514DDC.70607@marquesminen.com.ar>
Date: Sat, 01 Dec 2007 09:04:44 -0300
From: Martin Marques <martin@marquesminen.com.ar>
User-Agent: Thunderbird 2.0.0.5 (X11/20070727)
MIME-Version: 1.0
To: Tomasz Ostrowski <tometzky@batory.org.pl>
CC: rihad@mail.ru,  pgsql-general@postgresql.org
Subject: Re: full_page_writes = off?
References: <4751150F.8080604@mail.ru> <20071201114754.GA2552@batory.org.pl>
In-Reply-To: <20071201114754.GA2552@batory.org.pl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/7
X-Sequence-Number: 124752

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