X-Original-To: pgsql-performance@postgresql.org Received: from mailserver1.hrz.tu-darmstadt.de (mailserver1.hrz.tu-darmstadt.de [130.83.126.41]) by postgresql.org (Postfix) with ESMTP id 3AA694760CC for ; Fri, 7 Mar 2003 03:44:42 -0500 (EST) Received: from paris (paris.dvs1.informatik.tu-darmstadt.de [130.83.27.43]) by mailserver1.hrz.tu-darmstadt.de (8.12.8/8.12.8) with ESMTP id h278iNEq004951; Fri, 7 Mar 2003 09:44:24 +0100 Received: from dvs1.informatik.tu-darmstadt.de (bali [130.83.27.100]) by paris (Postfix) with ESMTP id 2949FFF05; Fri, 7 Mar 2003 09:44:23 +0100 (MET) Message-ID: <3E685BE6.4090008@dvs1.informatik.tu-darmstadt.de> Date: Fri, 07 Mar 2003 09:44:22 +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: Rod Taylor Cc: Mario Weilguni , Manfred Koizar , Postgresql Performance Subject: Re: Write ahead logging References: <3E5494DA.20003@dvs1.informatik.tu-darmstadt.de> <000b01c2d8c2$54008350$8f01c00a@icomedias.com> <3E55E8E0.60201@dvs1.informatik.tu-darmstadt.de> <1046993755.487.86.camel@jester> In-Reply-To: <1046993755.487.86.camel@jester> 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: 8bit X-MailScanner: Found to be clean X-Archive-Number: 200303/57 X-Sequence-Number: 1355 Rod Taylor wrote: > What were you using to measure the latency. Don't suppose you could > send it over. The admins locally don't like what I used to do the test > with -- they don't want to turn off write-caching for other reasons. I am doing an insert of few bytes, so that the amount of data does not significantly affect the measured time. And for measuring time without cache, I temporarily switched it off. That was the code used (nothing unusual): #include "timeval.h" main() { Timeval start,end; EXEC SQL WHENEVER sqlerror sqlprint; EXEC SQL WHENEVER not found sqlprint; EXEC SQL CONNECT TO user@localhost; start=Timeval::Time(); EXEC SQL BEGIN; EXEC SQL INSERT INTO test values ('qwertz'); EXEC SQL COMMIT; end=Timeval::Time(); end-=start; printf("time: %d.%06d\n",end.tv_sec,end.tv_usec); } - Matthias Meixner -- Matthias Meixner meixner@informatik.tu-darmstadt.de Technische Universität Darmstadt Datenbanken und Verteilte Systeme Telefon (+49) 6151 16 6232 Wilhelminenstraße 7, D-64283 Darmstadt, Germany Fax (+49) 6151 16 6229