X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 24A91474E61 for ; Thu, 20 Feb 2003 04:32:23 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 19934-07 for ; Thu, 20 Feb 2003 04:32:12 -0500 (EST) Received: from relay12.austria.eu.net (relay12.Austria.eu.net [193.154.160.116]) by postgresql.org (Postfix) with ESMTP id 48FDB474E5C for ; Thu, 20 Feb 2003 04:32:12 -0500 (EST) Received: from relay2.austria.eu.net (endjinn.austria.eu.net [193.81.13.2]) by relay12.austria.eu.net (Postfix) with ESMTP id D581DC561F; Thu, 20 Feb 2003 10:32:07 +0100 (CET) Received: from ICOMWE (office.icomedias.com [62.99.232.80] (may be forged)) by relay2.austria.eu.net (8.12.6/8.12.6) with SMTP id h1K9Th3V003367; Thu, 20 Feb 2003 10:30:07 +0100 (MET) Message-ID: <000b01c2d8c2$54008350$8f01c00a@icomedias.com> From: "Mario Weilguni" To: "Manfred Koizar" , "Matthias Meixner" Cc: References: <3E5494DA.20003@dvs1.informatik.tu-darmstadt.de> Subject: Re: Write ahead logging Date: Thu, 20 Feb 2003 10:27:46 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/136 X-Sequence-Number: 1192 > >So the question is: has anybody verified, that the log is written to disk > >before returning from commit? > > Some (or all?) IDE disks are known to lie: they report success as > soon as the data have reached the drive's RAM. under linux, hdparm -W can turn off the write cache of IDE disk, maybe you should try with write-caching turned off. best regards, mario weilguni