X-Original-To: pgsql-performance@postgresql.org Received: from jester.inquent.com (unknown [216.208.117.7]) by postgresql.org (Postfix) with ESMTP id BBDED47647B for ; Thu, 6 Mar 2003 18:35:25 -0500 (EST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by jester.inquent.com (8.12.6/8.12.6) with ESMTP id h26NZuhn028169; Thu, 6 Mar 2003 18:36:06 -0500 (EST) (envelope-from rbt@rbt.ca) Subject: Re: Write ahead logging From: Rod Taylor To: Matthias Meixner Cc: Mario Weilguni , Manfred Koizar , Postgresql Performance In-Reply-To: <3E55E8E0.60201@dvs1.informatik.tu-darmstadt.de> References: <3E5494DA.20003@dvs1.informatik.tu-darmstadt.de> <000b01c2d8c2$54008350$8f01c00a@icomedias.com> <3E55E8E0.60201@dvs1.informatik.tu-darmstadt.de> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-doG/irtiL5snTvCvWKzR" Organization: Message-Id: <1046993755.487.86.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 Date: 06 Mar 2003 18:35:56 -0500 X-Archive-Number: 200303/51 X-Sequence-Number: 1349 --=-doG/irtiL5snTvCvWKzR Content-Type: text/plain Content-Transfer-Encoding: quoted-printable 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. On Fri, 2003-02-21 at 03:52, Matthias Meixner wrote: > Mario Weilguni wrote: > >>>So the question is: has anybody verified, that the log is written to d= isk > >>>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. >=20 > Yes, that made a big difference. Latency went up to 25-95ms. >=20 > Regards, >=20 > Matthias Meixner --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-doG/irtiL5snTvCvWKzR Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (FreeBSD) iD8DBQA+Z9tb6DETLow6vwwRAkv+AJ0T7dk6RtoZ1UNB/c2nwNHTtdtzPgCfX65I jm5fX4T0QEG7ORaDGgaaRgY= =/IjU -----END PGP SIGNATURE----- --=-doG/irtiL5snTvCvWKzR--