Re: Database/table limits ?????? - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Database/table limits ??????
Date
Msg-id 200006011823.OAA20112@candle.pha.pa.us
Whole thread Raw
In response to Re: Database/table limits ??????  (Chris Albertson <calbertson@logicon.com>)
List 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@logicon.com                  Voice: 626-351-0089  x17
>   Logicon, Pasadena California            Fax:   626-351-0699
>


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

pgsql-admin by date:

Previous
From: Chris Albertson
Date:
Subject: Re: Database/table limits ??????
Next
From: Peter Eisentraut
Date:
Subject: Re: Re: few more securiry questions :-)