X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4EEA4475A71 for ; Fri, 21 Feb 2003 09:27:44 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 93062-03 for ; Fri, 21 Feb 2003 09:27:33 -0500 (EST) Received: from mailserver1.hrz.tu-darmstadt.de (mailserver1.hrz.tu-darmstadt.de [130.83.126.41]) by postgresql.org (Postfix) with ESMTP id 84F1A474E5C for ; Fri, 21 Feb 2003 09:27:23 -0500 (EST) Received: from paris (paris.dvs1.informatik.tu-darmstadt.de [130.83.27.43]) by mailserver1.hrz.tu-darmstadt.de (8.12.1/8.12.1) with ESMTP id h1L8qowY014076; Fri, 21 Feb 2003 09:52:55 +0100 Received: from dvs1.informatik.tu-darmstadt.de (bali [130.83.27.100]) by paris (Postfix) with ESMTP id 061DCFEFF; Fri, 21 Feb 2003 09:52:48 +0100 (MET) Message-ID: <3E55E8E0.60201@dvs1.informatik.tu-darmstadt.de> Date: Fri, 21 Feb 2003 09:52:48 +0100 From: Matthias Meixner User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: de, en MIME-Version: 1.0 To: Mario Weilguni Cc: Manfred Koizar , pgsql-performance@postgresql.org Subject: Re: Write ahead logging References: <3E5494DA.20003@dvs1.informatik.tu-darmstadt.de> <000b01c2d8c2$54008350$8f01c00a@icomedias.com> In-Reply-To: <000b01c2d8c2$54008350$8f01c00a@icomedias.com> X-Enigmail-Version: 0.71.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/150 X-Sequence-Number: 1206 Mario Weilguni wrote: >>>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. >=20 >=20 > under linux, hdparm -W can turn off the write cache of IDE disk, maybe you > should try with write-caching turned off. Yes, that made a big difference. Latency went up to 25-95ms. Regards, Matthias Meixner --=20 Matthias Meixner meixner@informatik.tu-darmstadt.de Technische Universit=E4t Darmstadt Datenbanken und Verteilte Systeme Telefon (+49) 6151 16 6232 Wilhelminenstra=DFe 7, D-64283 Darmstadt, Germany Fax (+49) 6151 16 6229