From ab71c20fdf7dbd63638a163ca628821643a3cfd4 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sun, 28 Jan 2001 17:39:44 +0000 Subject: Update FAQ. --- doc/FAQ | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'doc/FAQ') diff --git a/doc/FAQ b/doc/FAQ index 6ae1a8d19e9..373223a40fc 100644 --- a/doc/FAQ +++ b/doc/FAQ @@ -639,7 +639,7 @@ These are the limits: Maximum size for a database? unlimited (60GB databases exist) -Maximum size for a table? 64 TB on all operating systems +Maximum size for a table? 16 TB Maximum size for a row? unlimited in 7.1 and later Maximum size for a field? 1GB in 7.1 and later Maximum number of rows in a table? unlimited @@ -650,6 +650,13 @@ Maximum number of indexes on a table? unlimited disk space and memory/swap space. Performance may suffer when these values get unusually large. + The maximum table size of 16TB does not require large file support + from the operating system. Large tables are stored as multiple 1GB + files. + + The maximum table size and maximum number of columns can be increased + by four if the default block size is increased to 32k. + 4.7) How much database disk space is required to store data from a typical text file? -- cgit v1.2.3