Re: Do Petabyte storage solutions exist? - Mailing list pgsql-admin

Ingres 6.4 is pretty much history and i'm not even sure if it's
supported by CA any more. Better use 2.5 or 2.6 !  It's offered
for Linux as well.

Regarding performance problems, there are a lot of parameters
to tune an Ingres database. The standard installation out of
the box is never sufficient for a realworld application.
The problem is performance, as you stated quite correctly.
You always have to scale Ingres to your machine's size and
resources, it's preconfigured for a very small machine.

BTW Ingres has quite a remarkable replication system where
you can have multiple master sites where inserts und updates
can happen. They've taken an asynchronous approach that allows sites
or networks to be down for a while without blocking a local
application's transaction. Collision detection it up to you
however, and there is not much help but doing it manually.
i'm currently writing and administering an application with sites
residing in Germany, US, South America, all having write access
and networks being down from time to time. Database size is in a
2-digit Gigabyte range.

Bye.



-----Ursprüngliche Nachricht-----
Von: Bradley Kieser [mailto:brad@kieser.net]
Gesendet: Freitag, 2. April 2004 14:03
An: Jürgen Cappel
Betreff: Re: AW: [ADMIN] Do Petabyte storage solutions exist?


Yeah, sorry, my mistake. Thanks for th e correction!

But I had serious problems getting a DB with large tables running on
Ingres 6.4, Sequent Dynix cluster. We had all sorts of errors on the
views and performance bombed badly. I really don't think that 6.4 at
least will scale to 100s GB but please tell me if you disagree because I
would like to know other experiences.


Jürgen Cappel wrote:

>You're also a bit rusty on Ingres. There was a problem
>with the early 2.5 version being limited to 2^31 bytes
>per table. That was fixed end of 2000, early 2001. I'm
>having table sizes in a production database of almost
>10 GB since then without problems. Bye.
>
>
>
>-----Ursprüngliche Nachricht-----
>Von: pgsql-admin-owner@postgresql.org
>[mailto:pgsql-admin-owner@postgresql.org]Im Auftrag von Bradley Kieser
>Gesendet: Freitag, 2. April 2004 12:36
>An: Tony and Bryn Reina
>Cc: pgsql-admin@postgresql.org
>Betreff: Re: [ADMIN] Do Petabyte storage solutions exist?
>
>
>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
>>
>>
>>
>>
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>
>