Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 053F52E37B6 for ; Sat, 1 Dec 2007 07:48:09 -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 94079-10 for ; Sat, 1 Dec 2007 07:48:00 -0400 (AST) Received: from szalupa.batory.org.pl (pompka.batory.org.pl [62.89.72.236]) by postgresql.org (Postfix) with ESMTP id 37E642E37A0 for ; Sat, 1 Dec 2007 07:48:03 -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 lB1Bm1mr022288 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sat, 1 Dec 2007 12:48:02 +0100 Received: from opal.localdomain (localhost.localdomain [127.0.0.1]) by opal.localdomain (8.14.1/8.14.1) with ESMTP id lB1Blwnq002624; Sat, 1 Dec 2007 12:47:58 +0100 Received: (from tometzky@localhost) by opal.localdomain (8.14.1/8.14.1/Submit) id lB1Blvcd002623; Sat, 1 Dec 2007 12:47:57 +0100 X-Authentication-Warning: opal.localdomain: tometzky set sender to using -f Date: Sat, 1 Dec 2007 12:47:57 +0100 From: Tomasz Ostrowski To: rihad Cc: pgsql-general@postgresql.org Subject: Re: full_page_writes = off? Message-ID: <20071201114754.GA2552@batory.org.pl> References: <4751150F.8080604@mail.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4751150F.8080604@mail.ru> 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/6 X-Sequence-Number: 124751 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) I don't know how to check it on BSD. It can be on for extra performance only if your disks are connected to battery backed RAID controller. 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