Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 207461337B6D for ; Fri, 5 Nov 2010 08:17:41 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 72670-03 for ; Fri, 5 Nov 2010 11:17:34 +0000 (UTC) X-Greylist: delayed 00:06:04.993166 by SQLgrey-1.7.6 Received: from mail.mnc.ch (62-2-77-205.static.cablecom.ch [62.2.77.205]) by mail.postgresql.org (Postfix) with ESMTP id C7DC21337B83 for ; Fri, 5 Nov 2010 08:17:33 -0300 (ADT) Received: from localhost (mail2.mnc.ch [127.0.0.1]) by mail.mnc.ch (Postfix) with ESMTP id 6A92123048; Fri, 5 Nov 2010 11:11:26 +0000 (GMT) X-Virus-Scanned: amavisd-new at mnc.ch Received: from mail.mnc.ch ([127.0.0.1]) by localhost (mail2.mnc.ch [127.0.0.1]) (amavisd-new, port 10025) with LMTP id ANf3wkmFvaSG; Fri, 5 Nov 2010 11:11:26 +0000 (GMT) Received: from meuh.localdomain (62-2-77-204.static.cablecom.ch [62.2.77.204]) by mail.mnc.ch (Postfix) with ESMTP id 02B4123047; Fri, 5 Nov 2010 11:11:26 +0000 (GMT) Received: by meuh.localdomain (Postfix, from userid 1000) id D53F4110275; Fri, 5 Nov 2010 12:11:25 +0100 (CET) To: A B Cc: pgsql-performance@postgresql.org Subject: Re: Running PostgreSQL as fast as possible no matter the consequences References: From: Guillaume Cottenceau X-Hashcash: 1:21:101105:gentosaker@gmail.com::GSvKZRzLeaTic2s+:000000000000000000000000000000000000000001KRp X-Hashcash: 1:21:101105:pgsql-performance@postgresql.org::HRa32xjstZVoKIDU:000000000000000000000000000000kj8 Date: Fri, 05 Nov 2010 12:11:25 +0100 In-Reply-To: (A. B.'s message of "Fri\, 5 Nov 2010 11\:59\:43 +0100") Message-ID: <87sjzgxbxe.fsf@meuh.mnc.lan> User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.3 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201011/46 X-Sequence-Number: 41070 A B writes: > Hi there. > > If you just wanted PostgreSQL to go as fast as possible WITHOUT any > care for your data (you accept 100% dataloss and datacorruption if any > error should occur), what settings should you use then? Don't use PostgreSQL, just drop your data, you will end up with the same results and be even faster than any use of PostgreSQL. If anyone needs data, then just say you had data corruption, and that since 100% dataloss is accepted, then all's well. -- Guillaume Cottenceau