clarification of postgres limitations

From: mbc(at)soliton(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: clarification of postgres limitations
Date: 2004-03-03 22:50:00
Message-ID: 20040303225000.GA20302@diamond.soliton.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

According to the official documentation:

-------------------------------------------------------------------------

Limitations of PostgreSQL
Maximum size for a database unlimited (4 TB databases exist)
Maximum size for a table 16 TB on all operating systems
Maximum size for a row 1.6 TB
Maximum size for a field 1 GB
Maximum number of rows in a table unlimited
Maximum number of columns in a table 250 - 1600 depending on column types
Maximum number of indexes on a table unlimited

Of course, these are not actually unlimited, but limited to available disk
space and memory/swap space. Performance may suffer when these values get
unusually large.

The maximum table size of 16 TB does not require large file support from
the operating system. Large tables are stored as multiple 1 GB files so file
system size limits are not important.

The maximum table size and maximum number of columns can be increased if
the default block size is increased to 32k.

-------------------------------------------------------------------------

Since it seems that the location of the server's data store is bound to a
single directory, a database cannot span across multiple file systems.
Further, does it imply that the maxiumum size of a database cannot exceed
the maximum size of the underlying file system?

--
"Nothing is either good or bad, but thinking makes it so." -- Shakespeare
--
Myron B Cheung (Soliton Associates) mailto: mbc(at)soliton(dot)com

Browse pgsql-general by date

  From Date Subject
Next Message Karl O. Pinc 2004-03-03 23:13:19 REFERENCES error message complaint, suggestion
Previous Message Ben 2004-03-03 22:15:20 Re: Simple, but VERYuseful enhancement for psql command - or am I missing something?