Received: from web10011.mail.yahoo.com (web10011.mail.yahoo.com
	[216.136.172.122])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0R8Xrq33371
	for <pgsql-admin@postgresql.org>; Sat, 27 Jan 2001 03:33:54 -0500 (EST)
	(envelope-from mrk279@yahoo.com)
Message-ID: <20010127083349.2592.qmail@web10011.mail.yahoo.com>
Received: from [212.95.170.12] by web10011.mail.yahoo.com;
	Sat, 27 Jan 2001 00:33:49 PST
Date: Sat, 27 Jan 2001 00:33:49 -0800 (PST)
From: R D <mrk279@yahoo.com>
Subject: Re: postgres limitation
To: a <hong@cs.purdue.edu>
Cc: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Archive-Number: 200101/169
X-Sequence-Number: 546

Hi,
The FAQ says:
_________________________________________________
4.6) What is the maximum size for a row, table,
database?

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?                  
                   unlimited in 7.1 and later
Maximum number of rows in a table?       
                   unlimited
Maximum number of columns in a table?    
                   unlimited
Maximum number of indexes on a table?    
                   unlimited

Of course, these are not actually unlimited, but
limited to available disk space.
_________________________________________________

I would like to add:
In the earlyer versions than 7.1 there is a limit of
8K per row configurable to 32K per row at compiletime.

regards,
Rumen
 
--- a <hong@cs.purdue.edu> wrote:
> Hi,
> 
> Is there any document about the limitation of
> postgres
> like the total size of one table
> the max row number of a table
> the max size of a row...
> 
> Thanks
> Feng
> 
> 
> 
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices. 
http://auctions.yahoo.com/