[SunRescue] solaris7 i/o tuning

[Joshua D. Boyd]

On Tue, 22 May 2001, Patrick Giagnocavo wrote:

> On Mon, May 21, 2001 at 08:47:24PM -0400, Dave McGuire wrote:
> > On May 21, Patrick Giagnocavo wrote:
> > > zippy, provided you can stand its crappy subpar SQL interface (subselects,
> > > transactions, and real ACID-ity just aren't there).  
> > 
> >   Well I certainly don't need any "fancy" SQL stuff...this is a simple
> > application.
> 
> I don't know your application, but my guess is that sooner or later you
> would be able to take advantage of the added SQL features that are supported.
> 
> Plus, you can write your own functions and call them within SQL, plus add a
> trigger which is run whenever you add/update/delete data.  One app I am
> familiar with keeps a separate audit table which just holds old versions of
> the data - a trigger on the table inserts the old data whenever there is an
> update or delete.
 
Yeah, no matter how simple you think your task is, you will probably end
up wishing for some features from real DBMSs.  I always find myself
wanting more whenever I'm working in Access of MySQL.

> >   Can't do that...this is gonna be many gigabytes of data.
> 
> Both MySQL and PG have some limitations when you get to either 4GB or 2GB.
> Dunno about MySQL, but under PG no single table can be more than 2GB in
> size.  If you run on Alpha (and maybe Sparc/64) the limit is much higher
> than 2GB.

I thought the limit was 2GB per database.  That is just there because of
platform limitations, and I'm not even sure it is there for all platforms.
To quote the website:

Limitations of PostgreSQL
Maximum size for a database: unlimited (60GB databases exist) 
Maximum size for a table: 64 TB on all operating systems 
Maximum size for a row: unlimited in 7.1 and later 
Maximum size for a field: 1GB in 7.1 and later 
Maximum number of rows in a table: unlimited 
Maximum number of columns in a table: 1600 
Maximum number of indexes on a table: unlimited 

I know of numerous large databases in PostGres.  It seems to be quite
popular with biologists amoung other things.

--
Joshua Boyd