Re: White paper on very big databases

From: Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>
To: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
Cc: jd(at)commandprompt(dot)com, Jean-Paul Argudo <jean-paul(at)postgresqlfr(dot)org>, PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: White paper on very big databases
Date: 2009-02-09 19:00:47
Message-ID: 49907D5F.8090401@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

Jonah H. Harris wrote:
> On Wed, Feb 4, 2009 at 12:09 PM, Joshua D. Drake <jd(at)commandprompt(dot)com
> <mailto:jd(at)commandprompt(dot)com>> wrote:
>
> Well therein lies the problem. CMD has a customer with a
> multi-terrabyte
> table (not including the rest of the database) but we can't really
> talk
> about it :(
>
>
> IIRC, EnterpriseDB had one customer with over 1TB of data, but they
> too would have been hush-hush about it. When I was consulting, I saw
> very few Postgres databases at or over 1TB. While Postgres can handle
> fairly large data sets, it lacks some fairly important VLDB features
> which is probably why there are so few people with multi-terabyte PG
> databases. Perhaps JD/Fetter know of more, but I can count the ones I
> know of at < 10.
>
> --
> Jonah H. Harris, Senior DBA
> myYearbook.com
>

hello everybody,

i know GIS databases which are ways bigger than 1 TB.
the biggest one i have seen personally recently was around 8 TB.
i had my hands on a 12 TB biest 3 years ago.

for the database size is not the real problem; the problem is rather
getting stuff in.
for most people the question is: is there anything we could still store
which would finally end up being 12 TB or more :). 80% of all people
will never get there even if they store every little movement everywhere :).

hans

--
Cybertec Schönig & Schönig GmbH
Professional PostgreSQL Consulting, Support, Training
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Web: www.postgresql-support.de

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Christophe 2009-02-09 22:35:55 Postgres-enabled ISPs?
Previous Message Thomas Finneid 2009-02-07 23:56:03 Re: weaknesses and strenghts of PG