From 69ab90c7753c08bd192f70c24fab178c7261b829 Mon Sep 17 00:00:00 2001
From: Bruce Momjian Last updated: Fri Feb 24 23:28:40 EST 2006 Last updated: Sun Apr 2 23:40:12 EDT 2006 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
@@ -169,7 +169,7 @@
PostgreSQL Data Base Management System Portions Copyright (c) 1996-2005, PostgreSQL Global Development Group
+ Portions Copyright (c) 1996-2006, PostgreSQL Global Development Group
Portions Copyright (c) 1994-1996 Regents of the University of California Permission to use, copy, modify, and distribute this software
@@ -654,7 +654,7 @@
Frequently Asked Questions (FAQ) for PostgreSQL
- Maximum size for a database? unlimited (32 TB databases
exist)
-Maximum size for a table? 32 TB
+Maximum size for a row? 1.6TB Maximum size for a row? 400 GB Maximum size for a field? 1 GB Maximum number of rows in a table? unlimited
multiple 1 GB files so file system size limits are not
important.Maximum number of columns in a table? 250-1600 depending
@@ -673,8 +673,8 @@ table? unlimited
The maximum table size and maximum number of columns can be - quadrupled by increasing the default block size to 32k.
+The maximum table size, row size, and maximum number of columns + can be quadrupled by increasing the default block size to 32k.
One limitation is that indexes can not be created on columns longer than about 2,000 characters. Fortunately, such indexes are -- cgit v1.2.3