pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jürgen Cappel <email@juergen-cappel.de>
To: Bradley Kieser <brad@kieser.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Do Petabyte storage solutions exist?
Date: Fri, 2 Apr 2004 13:45:49 +0200
Message-ID: <JEEKIPNAKJNCFLMOBKHGKEIGDCAA.email@juergen-cappel.de> (raw)
In-Reply-To: <406D568A.8020601@kieser.net>

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
>
>
>
>




view thread (30+ messages)  latest in thread

Message-ID: <JEEKIPNAKJNCFLMOBKHGKEIGDCAA.email@juergen-cappel.de>
Permalink:  ../JEEKIPNAKJNCFLMOBKHGKEIGDCAA.email@juergen-cappel.de/
Also on:    postgresql.org/message-id/JEEKIPNAKJNCFLMOBKHGKEIGDCAA.email@juergen-cappel.de

 · 

reply

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: email@juergen-cappel.de, brad@kieser.net
  Subject: Re: Do Petabyte storage solutions exist?
  In-Reply-To: <JEEKIPNAKJNCFLMOBKHGKEIGDCAA.email@juergen-cappel.de>
  References: <406D568A.8020601@kieser.net> <JEEKIPNAKJNCFLMOBKHGKEIGDCAA.email@juergen-cappel.de>

* 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