X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 694C6474E4F for ; Thu, 20 Feb 2003 04:18:36 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 12055-07 for ; Thu, 20 Feb 2003 04:18:25 -0500 (EST) Received: from email02.aon.at (WARSL402PIP7.highway.telekom.at [195.3.96.94]) by postgresql.org (Postfix) with SMTP id 2D926475458 for ; Thu, 20 Feb 2003 04:18:25 -0500 (EST) Received: (qmail 149680 invoked from network); 20 Feb 2003 09:18:01 -0000 Received: from m169p001.dipool.highway.telekom.at (HELO cantor) ([62.46.11.1]) (envelope-sender ) by qmail2rs.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 20 Feb 2003 09:18:01 -0000 From: Manfred Koizar To: Matthias Meixner Cc: pgsql-performance@postgresql.org Subject: Re: Write ahead logging Date: Thu, 20 Feb 2003 10:17:31 +0100 Message-ID: References: <3E5494DA.20003@dvs1.informatik.tu-darmstadt.de> In-Reply-To: <3E5494DA.20003@dvs1.informatik.tu-darmstadt.de> X-Mailer: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/135 X-Sequence-Number: 1191 On Thu, 20 Feb 2003 09:42:02 +0100, Matthias Meixner wrote: >Using a slow disk (5400rpm) I measured about 3-5 ms for a commit. But >average rotational delay is already higher for that disk (5.5ms). >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. Servus Manfred