X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 09B2ED1B8C9 for ; Thu, 4 Sep 2003 06:56:22 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 08968-01 for ; Thu, 4 Sep 2003 03:55:52 -0300 (ADT) Received: from fuji.krosing.net (unknown [194.204.44.104]) by svr1.postgresql.org (Postfix) with ESMTP id 67E59D1B8D3 for ; Thu, 4 Sep 2003 03:55:49 -0300 (ADT) Received: from fuji.krosing.net (localhost.localdomain [127.0.0.1]) by fuji.krosing.net (8.12.8/8.12.8) with ESMTP id h846tVsC007934; Thu, 4 Sep 2003 09:55:31 +0300 Received: (from hannu@localhost) by fuji.krosing.net (8.12.8/8.12.8/Submit) id h846tRHG007932; Thu, 4 Sep 2003 09:55:27 +0300 X-Authentication-Warning: fuji.krosing.net: hannu set sender to hannu@tm.ee using -f Subject: Re: PostgreSQL Reliability when fsync = false on From: Hannu Krosing To: Rod Taylor Cc: Federico Sevilla III , PostgreSQL Performance Mailing List , Linux-XFS Mailing List In-Reply-To: <1062646595.84923.35.camel@jester> References: <20030904030404.GA32319@leathercollection.ph> <1062646595.84923.35.camel@jester> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1062658526.6270.5.camel@fuji.krosing.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Thu, 04 Sep 2003 09:55:27 +0300 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/51 X-Sequence-Number: 3417 Rod Taylor kirjutas N, 04.09.2003 kell 06:36: > Another alternative is > to buy a small 15krpm disk dedicated for WAL. In theory you can achieve > one commit per rotation. One commit per rotation would still be only 15000/60. = 250 tps, but fortunately you can get better results if you use multiple concurrent backends, then in the best case you can get one commit per backend per rotation. ----------------- Hannu