Re: looking for some real world performance numbers - Mailing list pgsql-general

From Gregory Stark
Subject Re: looking for some real world performance numbers
Date
Msg-id 87wstfzawd.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: looking for some real world performance numbers  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: looking for some real world performance numbers  (Bill Moran <wmoran@potentialtech.com>)
Re: looking for some real world performance numbers  (Erik Jones <erik@myemma.com>)
List pgsql-general
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> Thomas Kellerer <spam_eater@gmx.net> writes:
>> Where else do they want to store relational data than in a RDBMS?
>
> Indeed.  It seems like we can hardly answer the OP's question without
> asking "compared to what?"  If they're afraid an RDBMS won't scale,
> what have they got in mind that they are so certain will scale?

I suspect they're misapplying the lesson Google taught everyone. Namely that
domain-specific solutions can provide much better performance than
general-purpose software.

Google might not use an RDBMS to store their search index (which doesn't need
any of the ACID guarantees and needs all kinds of parallelism and lossy
alorithms which SQL and RDBMSes in general don't excel at), but on the other
hand I would be quite surprised if they stored their Adsense or other more
normal use data structures in anything but a bog-standard SQL database.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
Next
From: Michael Fuhr
Date:
Subject: Re: looking for some real world performance numbers