Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 2B03B1337C01 for ; Fri, 5 Nov 2010 09:06:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 86892-01-7 for ; Fri, 5 Nov 2010 12:06:39 +0000 (UTC) X-Greylist: from auto-whitelisted 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 9A3511337C0C for ; Fri, 5 Nov 2010 09:06:30 -0300 (ADT) Received: from localhost (mail2.mnc.ch [127.0.0.1]) by mail.mnc.ch (Postfix) with ESMTP id CA10823048; Fri, 5 Nov 2010 12:06:30 +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 Ok9a+64TMn9O; Fri, 5 Nov 2010 12:06:25 +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 7C86623047; Fri, 5 Nov 2010 12:06:25 +0000 (GMT) Received: by meuh.localdomain (Postfix, from userid 1000) id 41B23110275; Fri, 5 Nov 2010 13:06:25 +0100 (CET) To: Marti Raudsepp Cc: A B , pgsql-performance@postgresql.org Subject: Re: Running PostgreSQL as fast as possible no matter the consequences References: <87sjzgxbxe.fsf@meuh.mnc.lan> From: Guillaume Cottenceau X-Hashcash: 1:21:101105:marti@juffo.org::7ros9kPAzEhJvWaV:007RlS X-Hashcash: 1:21:101105:gentosaker@gmail.com::GWuNk7XZiiYsGW3E:000000000000000000000000000000000000000002n+N X-Hashcash: 1:21:101105:pgsql-performance@postgresql.org::gXTQQsH9LydCJq+E:000000000000000000000000000002NWm Date: Fri, 05 Nov 2010 13:06:25 +0100 In-Reply-To: (Marti Raudsepp's message of "Fri\, 5 Nov 2010 13\:30\:41 +0200") Message-ID: <87lj58vuta.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/55 X-Sequence-Number: 41079 Marti Raudsepp writes: > On Fri, Nov 5, 2010 at 13:11, Guillaume Cottenceau wrote: >> 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. > > You're not helping. There are legitimate reasons for trading off > safety for performance. Cccepting 100% dataloss and datacorruption deserves a little reasoning, otherwise I'm afraid I'm right in suggesting it makes little difference to use PG or to drop data altogether. -- Guillaume Cottenceau