From 54ee522f4fb0af1794b0d45deaed44fe1b979538 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 1 Jun 2000 05:13:18 +0000 Subject: Fixups for 7.0.1 --- doc/src/FAQ.html | 72 ++++++++++++++++++++++++++++++-------------------------- 1 file changed, 38 insertions(+), 34 deletions(-) (limited to 'doc/src/FAQ.html') diff --git a/doc/src/FAQ.html b/doc/src/FAQ.html index 1ed10902d88..bbee79245fe 100644 --- a/doc/src/FAQ.html +++ b/doc/src/FAQ.html @@ -18,12 +18,15 @@ Web site, http://www.PostgreSQL.org.

Linux-specific questions are answered in http://www.PostgreSQL.org/docs/faq-linux.html.

+HPUX-specific questions are answered in http://www.PostgreSQL.org/docs/faq-hpux.html.

+ +Solaris-specific questions are answered in http://www.postgresql.org/docs/faq-solaris.html.

+ Irix-specific questions are answered in http://www.PostgreSQL.org/docs/faq-irix.html.

-HPUX-specific questions are answered in http://www.PostgreSQL.org/docs/faq-hpux.shtml.

-

General Questions

@@ -42,7 +45,6 @@ HREF="http://www.PostgreSQL.org/docs/faq-hpux.shtml">http://www.PostgreSQL.org/d 1.12) How do I join the development team?
1.13) How do I submit a bug report?
1.14) How does PostgreSQL compare to other DBMS's?
-1.15) What are the maximum size limits?

User Client Questions

@@ -120,7 +122,8 @@ is NULL?
various character types?
4.16.1) How do I create a serial/auto-incrementing field?
4.16.2) How do I get the value of a serial insert?
-4.16.3) Wouldn't use of currval() and nextval() lead to a race condition with other concurrent backend processes?
+4.16.3) Don't currval() and nextval() lead to a +race condition with other concurrent backend processes?
4.17) What is an oid? What is a tid?
4.18) What is the meaning of some of the terms @@ -139,7 +142,7 @@ current time?

Extending PostgreSQL

5.1) I wrote a user-defined function. When I run -it in psql, why does it dumps core?
+it in psql, why does it dump core?
5.2) What does the message: NOTICE:PortalHeapMemoryFree: 0x402251d0 not in alloc set! mean?
5.3) How can I contribute some nifty new types and functions @@ -353,6 +356,10 @@ http://www.postgresql.org/docs/postgres. in the distribution.

+There is a PostgreSQL book availiable at +http://www.postgresql.org/docs/awbook.html

+ psql has some nice \d commands to show information about types, operators, functions, aggregates, etc.

@@ -367,6 +374,10 @@ TODO for a list of known bugs, missing features, and future plans.

1.10) How can I learn SQL?

+The PostgreSQL book at +http://www.postgresql.org/docs/awbook.html teaches SQL. + There is a nice tutorial at http://w3.one.net/~jhoffman/sqltut.htm and at http://members.tripod.com/er4ebus/sql/index.htm

Many of our users like The Practical SQL Handbook, Bowman et al., -Addison Wesley. Others like Lan Times Guide to SQL, Groff et al., -Osborne McGraw-Hill.

+Addison Wesley. Others like The Complete Reference SQL, Groff et al., +McGraw-Hill.

1.11) Is PostgreSQL Y2K compliant?

@@ -484,20 +495,6 @@ add our code to your product with no limitations, except those outlined in our BSD-style license stated above.

-

1.15) 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
-Maximun number of indexes on a table?	 unlimited
-
-The row length limit will be removed in 7.1.

-

User Client Questions

@@ -580,9 +577,8 @@ We have:

@@ -848,15 +844,23 @@ this:

4.6) What is the maximum size for a row, table, database?

-Rows are limited to 8K bytes, but this can be changed by editing -include/config.h and changing BLCKSZ. To use attributes -larger than 8K, you can also use the large object interface.

+These are the limits: -Rows do not cross 8k boundaries so a 5k row will require 8k of -storage.

+

+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
+Maximun number of indexes on a table?	 unlimited
+
+ +To change the maximum row size, edit include/config.h and change +BLCKSZ. To use attributes larger than 8K, you can also +use the large object interface.

+ +Row length limit will be removed in 7.1.

-Table and database sizes are unlimited. There are many databases that -are tens of gigabytes, and probably some that are hundreds.

4.7)How much database disk space is required to store data from a typical flat file?

@@ -1056,7 +1060,8 @@ Similarly, you could retrieve the just-assigned SERIAL value with the currval Finally, you could use the oid returned from the INSERT statement to lookup the default value, though this is probably the least portable approach. In perl, using DBI with Edmund Mergl's DBD::Pg module, the oid value is made available via $sth->{pg_oid_status} after $sth->execute(). -

4.16.3) Wouldn't use of currval() and nextval() lead to a race condition with other concurrent backend processes?

+

4.16.3) Don't currval() and nextval() lead to a race condition with other +concurrent backend processes?

No. That has been handled by the backends. @@ -1232,4 +1237,3 @@ have to do a make clean and then another make.

- -- cgit v1.2.3