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

Поиск
Список
Период
Сортировка
От Chris Albertson
Тема Re: Database/table limits ??????
Дата
Msg-id 3936A82A.9AB17F99@logicon.com
обсуждение исходный текст
Ответ на Re: Database/table limits ??????  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Database/table limits ??????
Список 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 по дате отправления:

Предыдущее
От: "Wallingford, Ted"
Дата:
Сообщение: RE: [SQL] Re: create view security
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Database/table limits ??????