Re: large dataset with write vs read clients

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: large dataset with write vs read clients
Date: 2010-10-10 07:20:55
Message-ID: 4CB16957.5020401@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message AI Rumman 2010-10-10 09:52:06 Db slow down after table partition
Previous Message Craig Ringer 2010-10-10 07:14:18 Re: Slow count(*) again...