X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 251C2D1D091 for ; Thu, 8 Apr 2004 06:01:28 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 39976-03 for ; Thu, 8 Apr 2004 06:01:26 -0300 (ADT) Received: from my.endian.it (unknown [62.146.87.34]) by svr1.postgresql.org (Postfix) with ESMTP id 350E1D1D08E for ; Thu, 8 Apr 2004 06:01:24 -0300 (ADT) Received: from [192.168.1.6] (host36-118.pool80180.interbusiness.it [80.180.118.36]) (authenticated (0 bits)) by my.endian.it (8.11.6/8.11.6) with ESMTP id i389XRl17246 for ; Thu, 8 Apr 2004 11:33:27 +0200 Subject: Re: data=writeback From: Chris To: pgsql-performance@postgresql.org In-Reply-To: <2A07EC2D0BC2774AAD6F74769F60D52A0832C6@ahmose.cict_ad.nl> References: <2A07EC2D0BC2774AAD6F74769F60D52A0832C6@ahmose.cict_ad.nl> Content-Type: text/plain Message-Id: <1081414889.5037.29.camel@dell> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Thu, 08 Apr 2004 11:01:29 +0200 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/101 X-Sequence-Number: 6401 > LABEL=/usr/local/pgsql /usr/local/pgsql ext3 > noatime,data=writeback 1 2 > LABEL=/usr/local/pgsql /usr/local/pgsql/wal ext3 > noatime,data=ordered 1 2 The same label mounted on two different mount points is probably I typo? I'm not sure if data=writeback is ok. I was wondering about the same thing after reading the "good pc but bad performance,why?" thread. This is from man mount: writeback Data ordering is not preserved - data may be written into the main file system after its metadata has been commit- ted to the journal. This is rumoured to be the highest- throughput option. It guarantees internal file system integrity, however it can allow old data to appear in files after a crash and journal recovery. How does this relate to fflush()? Does fflush still garantee all data has ben written? Bye, Chris.