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

From Chris Albertson
Subject Re: Database/table limits ??????
Date
Msg-id 3936A82A.9AB17F99@logicon.com
Whole thread Raw
In response to Re: Database/table limits ??????  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Database/table limits ??????  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Wallingford, Ted"
Date:
Subject: RE: [SQL] Re: create view security
Next
From: Bruce Momjian
Date:
Subject: Re: Database/table limits ??????