X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2034547580B for ; Thu, 20 Feb 2003 03:42:46 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 95390-05 for ; Thu, 20 Feb 2003 03:42:35 -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 04D1B475B85 for ; Thu, 20 Feb 2003 03:42:28 -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 h1K8g2nc018614 for ; Thu, 20 Feb 2003 09:42:02 +0100 Received: from dvs1.informatik.tu-darmstadt.de (bali [130.83.27.100]) by paris (Postfix) with ESMTP id 2EB4BFF05 for ; Thu, 20 Feb 2003 09:42:02 +0100 (MET) Message-ID: <3E5494DA.20003@dvs1.informatik.tu-darmstadt.de> Date: Thu, 20 Feb 2003 09:42:02 +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: pgsql-performance@postgresql.org Subject: Write ahead logging X-Enigmail-Version: 0.71.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed X-MailScanner: Found to be clean Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/134 X-Sequence-Number: 1190 Hi I am doing some performance testing using postgresql. When measuring the latency of commit I got some results, which make me doubt, if the logging data is written to disk in time: 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? System used was: Linux 2.4.20 filesystem: ext3 postgresql postgresql-7.2 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