From: | "Ohgaki Yasuo" <yasuo_ohgaki(at)hotmail(dot)com> |
---|---|
To: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | <pgsql-admin(at)postgreSQL(dot)org> |
Subject: | Re: Database/table limits ?????? |
Date: | 2000-06-01 01:58:32 |
Message-ID: | 20000601015939.66644.qmail@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
> I have added this to the PostgreSQL FAQ. Thanks.
>
>
> > I am running postgresql 6.5.2 on FreeBSD. I am developing a data warehouse
> > here at Utah State University. A quick look at the docs leaves the following
> > questions:
> >
> > 1. what is the maximum size for a database?
> > 2. what is the maximum size for a table?
> > 3. what is the maximum size for a row?
> > 4. What is the maximum number of rows in a table?
> > 5. What is the maximum number of items in a row/table?
> > 6. What is the maximun number of indexes to a table;
> > 7. What is the maximum size of an index file?
> > 8. Can a database be spread over more than one disk drive?
> > 9. Can a table be spread over more than one disk drive?
> > If the answer to 8 and or 9 is yes, how do I do it?
> >
== 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.
==============
Question:
- Are these limits apply to 6.5.3 also? all versions?
- What is the max size of Large Object?
- I believe each OS has it own limitations, so these means unlimited to OS limitations
such as max file size under certain OS and filesystem. Right?
(Original poster was asking similar questions. Database can spread over multiple disks, etc.
If it is the case, I can understand its really unlimited. I couldn't find answer in the FAQ.....)
I'm not familiar with PostgreSQL yet. Thanks.
A little HTML Problem:
"1.14)" supposed to be "1.15)" and there is no correct link to this item
from table of contents.
You probably already knows about this. Just in case you don't.
==
Yasuo Ohgaki
yasuo_ohgaki(at)hotmial(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2000-06-01 02:24:58 | Re: [SQL] Re: create view security |
Previous Message | brianb | 2000-06-01 01:41:27 | Vacuum Question |