X-Original-To: pgsql-jdbc@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 95366474E53; Mon, 17 Feb 2003 15:04:35 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id CA45E474E42; Mon, 17 Feb 2003 15:04:34 -0500 (EST) Received: from [66.219.92.2] (HELO chocolate-mousse) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2843978; Mon, 17 Feb 2003 12:04:41 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Tomasz Myrta , Rafal Kedziorski Subject: Re: [PERFORM] Good performance? Date: Mon, 17 Feb 2003 12:03:58 -0800 X-Mailer: KMail [version 1.4] Cc: pgsql-jdbc@postgresql.org, pgsql-performance@postgresql.org References: <5.2.0.9.0.20030216232710.01b40810@mail.polonium.de> <3E50A78D.9000806@polonium.de> <3E50C071.3090806@klaster.net> In-Reply-To: <3E50C071.3090806@klaster.net> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200302171203.58611.josh@agliodbs.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/257 X-Sequence-Number: 6428 Rafal, Tomasz, > It is possible when you have "fsync=3Dfalse" in your postgresql.conf.=20 > (don't change it if you don't have to). You should NOT turn off fsync unless you know what you are doing. With fsy= nc=20 off, your database can be unrecoverably corrupted after an unexpected=20 power-out, and you will be forced to restore from your last backup. --=20 -Josh Berkus Aglio Database Solutions San Francisco