Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 9906B1337BD3 for ; Sun, 10 Oct 2010 04:21:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 39376-02 for ; Sun, 10 Oct 2010 07:21:15 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.postnewspapers.com.au (202-89-185-120.static.dsl.amnet.net.au [202.89.185.120]) by mail.postgresql.org (Postfix) with ESMTP id 6803D1337BC3 for ; Sun, 10 Oct 2010 04:21:14 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id 083BEAF98C; Sun, 10 Oct 2010 15:21:13 +0800 (WST) X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au Received: from mail.postnewspapers.com.au ([127.0.0.1]) by localhost (mail.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id Soa+rdsu4kRA; Sun, 10 Oct 2010 15:21:07 +0800 (WST) Received: from [10.1.1.8] (124-148-209-200.dyn.iinet.net.au [124.148.209.200]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTPSA id B4AB8AEE65; Sun, 10 Oct 2010 15:21:06 +0800 (WST) Message-ID: <4CB16957.5020401@postnewspapers.com.au> Date: Sun, 10 Oct 2010 15:20:55 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.1.12) Gecko/20100914 Thunderbird/3.0.8 MIME-Version: 1.0 To: Mladen Gogala CC: pgsql-performance@postgresql.org Subject: Re: large dataset with write vs read clients References: <4CAE3FDB.1040909@2ndquadrant.com> <87ocb3yu10.fsf@mid.deneb.enyo.de> <4CB0E006.8010905@vmsinfo.com> <4CB16080.1050406@postnewspapers.com.au> <4CB1636B.3000006@vmsinfo.com> In-Reply-To: <4CB1636B.3000006@vmsinfo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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: 201010/88 X-Sequence-Number: 40507 On 10/10/2010 2:55 PM, Mladen Gogala wrote: > On 10/10/2010 2:43 AM, Craig Ringer wrote: >> >> Some of the other flavours of non-SQL databases, both those that've been >> around forever (PICK/UniVerse/etc, Berkeley DB, Cache, etc) and those >> that're new and fashionable Cassandra, CouchDB, etc, provide some ACID >> properties anyway. If you don't need/want an SQL interface to your >> database you don't have to throw out all that other database-y goodness >> if you haven't been drinking too much of the NoSQL kool-aid. > This is a terrible misunderstanding. You haven't taken a look at that > Youtube clip I sent you, have you? I'm not so good with video when I'm seeking information not entertainment. I really dislike having to sit and watch someone sloooowly get aroud to the point; give me something to skim read and I'll do that. The trend toward video news etc drives me nuts - IMO just detracting from the guts of the story/argument/explanation in most cases. One of the wonderful things about the written word is that everybody can benefit from it at their own natural pace. Video, like university lectures, takes that away and forces the video to be paced to the needs of the slowest. My dislike of video-as-information is a quirk that's clearly not shared by too many given how trendy video is becoming on the 'net. OTOH, it's probably not a grossly unreasonable choice when dealing with lots of mailing list posts/requests. Imagine if the Pg list accepted video link questions - ugh. Hey, maybe I should try posting YouTube video answers to a few questions for kicks, see how people react ;-) > I am an Oracle DBA, first and > foremost, disturbing the peace since 1989. I haven't been drinking the > NoSQL kool-aid at all. > I was simply being facetious. ACID rules are business rules and I am > bitterly opposed to relaxing them. BTW, my favorite drink is Sam Adams Ale. Aah, thanks. I completely missed it - which is a little scary, in that IMO that message could've been believably written in deadly earnest by a NoSQL over-enthusiast. Good work ... I think. Eek. Sam Adams ale, I'm afrid, does not travel well from Australia. -- Craig Ringer Tech-related writing at http://soapyfrogs.blogspot.com/