From: Bradley Kieser <brad@kieser.net>
To: Tony and Bryn Reina <reina_ga@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Do Petabyte storage solutions exist?
Date: Fri, 02 Apr 2004 10:36:12 +0000
Message-ID: <406D421C.4010506@kieser.net> (raw)
In-Reply-To: <BAY8-DAV18vHsCaB2YG00012cb8@hotmail.com>
References: <272e4be7.0404010941.4413c82c@posting.google.com>
<406C6513.9070105@kieser.net>
<BAY8-DAV18vHsCaB2YG00012cb8@hotmail.com>
Hi Tony,
Yep, for the time being you're pretty much limited to this for a table.
As far as commercial DBs go, IMHO (without knowing about DB2) Oracle is
the only player in town that will realistically deal with table sizes in
the order of 100sGB or more. Ingres has limitations similar to PG
although they will deny it, Informix I am a little bit rusty on now but
certainly when I used it last it didn't scale up much past the low
ordinal GBs per table and Sybase, IM v HO, is a joke anyway. Hope I
don't offend anyone with that last statement!
The wildcard here is DB2 because they have to renovated the code that I
cannot comment on it anymore.
Oracle's main drawbacks are:
a) VERY resource-intensive with a high process startup overhead.
b) VERY expensive. You are talking license fees into the £100 000s for
big iron installations.
But, as I said, IMHO, (and excluding DB2) Oracle is the only player to
look at.
Hope that this helps!
Brad
Tony and Bryn Reina wrote:
>----- Original Message -----
>From: "Bradley Kieser" <brad@kieser.net>
>To: "Tony Reina" <reina_ga@hotmail.com>
>Cc: <pgsql-admin@postgresql.org>
>Sent: Thursday, April 01, 2004 8:53 PM
>Subject: Re: [ADMIN] Do Petabyte storage solutions exist?
>
>
> let alone the storate limit of 2GB per
>
>
>>table. So sadly, PG would have to bow out of this IMHO unless someone
>>else nukes me on this!
>>
>>
>
>Uh oh, 2 GB limit on table sizes. I did realize the limit was that low.
>
>Would commercial DBMS be the better solution for handling Terabyte databases
>and above?
>
>
>-Tony
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: brad@kieser.net, reina_ga@hotmail.com
Subject: Re: Do Petabyte storage solutions exist?
In-Reply-To: <406D421C.4010506@kieser.net>
References: <272e4be7.0404010941.4413c82c@posting.google.com> <406C6513.9070105@kieser.net> <BAY8-DAV18vHsCaB2YG00012cb8@hotmail.com> <406D421C.4010506@kieser.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox