Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 011C62E37CC for ; Sat, 1 Dec 2007 08:16:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 39134-03 for ; Sat, 1 Dec 2007 08:16:10 -0400 (AST) Received: from szalupa.batory.org.pl (pompka.batory.org.pl [62.89.72.236]) by postgresql.org (Postfix) with ESMTP id 7B6542E37C6 for ; Sat, 1 Dec 2007 08:16:10 -0400 (AST) Received: from opal.localdomain (catv.spray.net.pl [83.143.40.134]) (authenticated bits=0) by szalupa.batory.org.pl (8.14.1/8.14.1) with ESMTP id lB1CG5mn022305 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sat, 1 Dec 2007 13:16:06 +0100 Received: from opal.localdomain (localhost.localdomain [127.0.0.1]) by opal.localdomain (8.14.1/8.14.1) with ESMTP id lB1CG36U002873; Sat, 1 Dec 2007 13:16:03 +0100 Received: (from tometzky@localhost) by opal.localdomain (8.14.1/8.14.1/Submit) id lB1CG1TL002872; Sat, 1 Dec 2007 13:16:01 +0100 X-Authentication-Warning: opal.localdomain: tometzky set sender to using -f Date: Sat, 1 Dec 2007 13:16:01 +0100 From: Tomasz Ostrowski To: Martin Marques Cc: rihad@mail.ru, pgsql-general@postgresql.org Subject: Re: full_page_writes = off? Message-ID: <20071201121601.GB2552@batory.org.pl> References: <4751150F.8080604@mail.ru> <20071201114754.GA2552@batory.org.pl> <47514DDC.70607@marquesminen.com.ar> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <47514DDC.70607@marquesminen.com.ar> User-Agent: Mutt/1.5.17 (2007-11-01) X-Scanned-By: MIMEDefang 2.62 on 62.89.72.236 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/8 X-Sequence-Number: 124753 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