Re: Database/table limits ??????

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Chris Albertson <calbertson(at)logicon(dot)com>
Cc: Ohgaki Yasuo <yasuo_ohgaki(at)hotmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Database/table limits ??????
Date: 2000-06-01 18:23:37
Message-ID: 200006011823.OAA20112@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

OK, but what do I put there?

>
> I looked at the FAQ also and IMO the word "unlimited" is a bit
> unrealistic. "unlimited" means without limits. Come on now!
> Postgres DOES have limits on the size of a database or table.
> Very large limits but still limits. For example could I build
> a table with 100 billion rows? No I'd run out of OIDs
> I think you can say "In practice the limits are imposed by the
> host OS and the processing power of current computers".
>
> Or with the number of columns in a table. You could say "The
> row length limit imposes a practical limit of XX columns".
>
> You want to have unquestioned credibility so when you make fun
> of the claims made by the MySQL people you are taken seriously.
>
>
>
> Ohgaki Yasuo wrote:
> >
> > I've take a look at the FAQ on www.postgresql.org
> >
> > A few questions and a little problem about FAQ html that I noticed.
> >
>
> <SNIP>
> >
> > == FROM FAQ ==
> > 1.14) What are the maximum size limits?
> > These are the limits:
> >
> > Maximum size for a database? unlimited (60GB databases exist)
> > Maximum size for a table? unlimited on all operating systems
> > Maximum size for a row? 8k, configurable to 32k
> > Maximum number of rows in a table? unlimited
> > Maximum number of columns table? unlimited
> > Maximum number of indexes on a table? unlimited
> >
> > The row length limit will be removed in 7.1.
> >
> > ==============
>
>
> --
> Chris Albertson
>
> calbertson(at)logicon(dot)com Voice: 626-351-0089 x17
> Logicon, Pasadena California Fax: 626-351-0699
>

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2000-06-02 00:37:17 Re: Re: few more securiry questions :-)
Previous Message Chris Albertson 2000-06-01 18:15:07 Re: Database/table limits ??????