X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7EDCA9FA220 for ; Fri, 2 Jun 2006 17:55:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 20068-05 for ; Fri, 2 Jun 2006 17:55:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from buraja.hst.terra.com.br (buraja.hst.terra.com.br [200.176.10.198]) by postgresql.org (Postfix) with ESMTP id B3BAE9FA0E5 for ; Fri, 2 Jun 2006 17:55:31 -0300 (ADT) Received: from tacamaca.hst.terra.com.br (tacamaca.hst.terra.com.br [200.176.10.13]) by buraja.hst.terra.com.br (Postfix) with ESMTP id 48AB622A40EE; Fri, 2 Jun 2006 17:55:29 -0300 (BRT) X-Terra-Karma: -2% X-Terra-Hash: 24ece3181ad89ea8b2f3aa529865f561 Received-SPF: pass (tacamaca.hst.terra.com.br: domain of terra.com.br designates 200.176.10.13 as permitted sender) client-ip=200.176.10.13; envelope-from=carlosreimer@terra.com.br; helo=reimer; Received: from reimer (unknown [200.180.59.84]) (authenticated user carlosreimer@terra.com.br) by tacamaca.hst.terra.com.br (Postfix) with ESMTP id 9257243440F5; Fri, 2 Jun 2006 17:55:29 -0300 (BRT) Reply-To: From: To: "Mark Lewis" Cc: Subject: RES: RES: RES: Initial database loading and IDE x SCSI Date: Fri, 2 Jun 2006 17:55:38 -0300 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: <1149281044.20798.116.camel@archimedes> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/16 X-Sequence-Number: 19373 > > Many thanks Mark, > >=20 > > I will consider fsync=3Doff only to do an initial load, not for a=20 > database normal operation. > >=20 >=20 > This approach works well. You just need to remember to shut down the > database and start it back up again with fsync enabled for it to be = safe > after the initial load. >=20 > > I was just thinking about this hipotetical scenario:=20 > > a) a restore database operation > > b) fsync off > > c) write-back on (IDE) > >=20 > > As I could understand, in this sceneraio, it=C2=B4s normal the IDE=20 > drive be faster than the SCSI, ok? > >=20 >=20 > If fsync is off, then the IDE drive loses its big advantage, so IDE = and > SCSI should be about the same speed. >=20 Sorry, I would like to say fsync on instead of fsync off. But I think I = understood. With fsync off the performance should be almost the same (SCSI and IDE), = and with fsync on=20 the IDE will be faster, but data are exposed. Thanks!