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