Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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

In response to

Responses

pgsql-admin by date

Next:From: Jan WieckDate: 2000-06-01 02:24:58
Subject: Re: [SQL] Re: create view security
Previous:From: brianbDate: 2000-06-01 01:41:27
Subject: Vacuum Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group