Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id B468D1337B71
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri,  5 Nov 2010 09:08:34 -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 55055-01
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri,  5 Nov 2010 12:08:27 +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 581C41337B74
	for <pgsql-performance@postgresql.org>;
	Fri,  5 Nov 2010 09:08:27 -0300 (ADT)
Received: from localhost (mail2.mnc.ch [127.0.0.1])
	by mail.mnc.ch (Postfix) with ESMTP id 9835A23048;
	Fri,  5 Nov 2010 12:08:27 +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 lM2qkvoS53a8; Fri,  5 Nov 2010 12:08:27 +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 2ADCB23047;
	Fri,  5 Nov 2010 12:08:27 +0000 (GMT)
Received: by meuh.localdomain (Postfix, from userid 1000)
	id EE35B110275; Fri,  5 Nov 2010 13:08:26 +0100 (CET)
To: Marti Raudsepp <marti@juffo.org>
Cc: A B <gentosaker@gmail.com>,  Szymon Guz <mabewlun@gmail.com>,
	pgsql-performance@postgresql.org
Subject: Re: Running PostgreSQL as fast as possible no matter the consequences
References: <AANLkTimcUYuutQeThCaP-077reGYWwdq-ssKwbPne8TO@mail.gmail.com>
	<AANLkTikVBTRkZCTiqzwRYemJhHLvwwrnA1WHguBpc5Qp@mail.gmail.com>
	<AANLkTin+ZRe5mEOj72ga8xOfbULpYn6kwH4hy_JCBYm2@mail.gmail.com>
	<AANLkTi=9CL-O=D_eiCxx7R=1zkGhimAotnGgB_WsvC2-@mail.gmail.com>
From: Guillaume Cottenceau <gc@mnc.ch>
X-Hashcash: 1:21:101105:marti@juffo.org::Y2jEMgWJt91m5yyb:00O7YB
X-Hashcash: 
 1:21:101105:gentosaker@gmail.com::EEs8aLefrVCQ7SZ9:00000000000000000000000000000000000000000Acpk
X-Hashcash: 
 1:21:101105:mabewlun@gmail.com::r/RHoe5RnDSUul7H:0000000000000000000000000000000000000000000G19x
X-Hashcash: 
 1:21:101105:pgsql-performance@postgresql.org::skzaqL2iEIsQfHne:00000000000000000000000000000EBNW
Date: Fri, 05 Nov 2010 13:08:26 +0100
In-Reply-To: <AANLkTi=9CL-O=D_eiCxx7R=1zkGhimAotnGgB_WsvC2-@mail.gmail.com>
	(Marti Raudsepp's message of "Fri\, 5 Nov 2010 13\:36\:34 +0200")
Message-ID: <87hbfwvupx.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=iso-8859-1
Content-Transfer-Encoding: 8bit
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/56
X-Sequence-Number: 41080

Marti Raudsepp <marti 'at' juffo.org> writes:

> On Fri, Nov 5, 2010 at 13:32, A B <gentosaker@gmail.com> wrote:
>> I was just thinking about the case where I will have almost 100%
>> selects, but still needs something better than a plain key-value
>> storage so I can do some sql queries.
>> The server will just boot, load data, run,  hopefully not crash but if
>> it would, just start over with load and run.
>
> If you want fast read queries then changing
> fsync/full_page_writes/synchronous_commit won't help you.

That illustrates how knowing the reasoning of this particular
requests makes new suggestions worthwhile, while previous ones
are now seen as useless.

-- 
Guillaume Cottenceau