diff options
| -rw-r--r-- | doc/FAQ | 19 | ||||
| -rw-r--r-- | doc/FAQ_AIX | 2 | ||||
| -rw-r--r-- | doc/FAQ_DEV | 4 | ||||
| -rw-r--r-- | doc/src/FAQ/FAQ.html | 27 |
4 files changed, 30 insertions, 22 deletions
@@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Wed Apr 12 16:03:39 EDT 2006 + Last updated: Thu Apr 13 08:20:04 EDT 2006 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -270,11 +270,12 @@ Addison-Wesley. Others like The Complete Reference SQL, Groff et al., McGraw-Hill. - There is also a nice tutorial at - http://www.intermedia.net/support/sql/sqltut.shtm, at - http://ourworld.compuserve.com/homepages/graeme_birchall/HTM_COOK.HTM, - and at http://sqlcourse.com. - + There are also many nice tutorials available online: + * http://www.intermedia.net/support/sql/sqltut.shtm + * http://sqlcourse.com + * http://www.w3schools.com/sql/default.asp + * http://mysite.verizon.net/Graeme_Birchall/id1.html + 1.12) How do I submit a patch or join the development team? See the Developer's FAQ. @@ -568,9 +569,9 @@ Indexes are normally not used for ORDER BY or to perform joins. A sequential scan followed by an explicit sort is usually faster than an - index scan of a large table. - However, LIMIT combined with ORDER BY often will use an index because - only a small portion of the table is returned. + index scan of a large table. However, LIMIT combined with ORDER BY + often will use an index because only a small portion of the table is + returned. If you believe the optimizer is incorrect in choosing a sequential scan, use SET enable_seqscan TO 'off' and run query again to see if an diff --git a/doc/FAQ_AIX b/doc/FAQ_AIX index 0e236d4df48..2d349ebf458 100644 --- a/doc/FAQ_AIX +++ b/doc/FAQ_AIX @@ -1,5 +1,5 @@ From: Zeugswetter Andreas <ZeugswetterA@spardat.at> -$Date: 2006/04/13 11:42:35 $ +$Date: 2006/05/19 03:34:49 $ On AIX 4.3.2 PostgreSQL compiled with the native IBM compiler xlc (vac.C 5.0.1) passes all regression tests. Other versions of OS and diff --git a/doc/FAQ_DEV b/doc/FAQ_DEV index 77fe10d3776..240e38d6e40 100644 --- a/doc/FAQ_DEV +++ b/doc/FAQ_DEV @@ -1,7 +1,7 @@ Developer's Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Wed Mar 1 17:24:48 EST 2006 + Last updated: Fri May 5 05:51:42 EDT 2006 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -575,7 +575,7 @@ General Questions * SQL:1999 http://www.cse.iitb.ac.in/dbms/Data/Papers-Other/SQL1999/ansi-iso- 9075-2-1999.pdf - * SQL:2003 http://www.wiscorp.com/sql/sql_2003_standard.zip + * SQL:2003 http://www.wiscorp.com/sql_2003_standard.zip Some SQL standards web pages are: * http://troels.arvin.dk/db/rdbms/links/#standards diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index c3512b61354..55f087379ea 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -10,7 +10,7 @@ alink="#0000ff"> <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> - <P>Last updated: Wed Apr 12 16:03:39 EDT 2006</P> + <P>Last updated: Thu Apr 13 08:20:04 EDT 2006</P> <P>Current maintainer: Bruce Momjian (<A href= "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>) @@ -356,14 +356,21 @@ Bowman, Judith S., et al., Addison-Wesley. Others like <I>The Complete Reference SQL</I>, Groff et al., McGraw-Hill.</P> - <P>There is also a nice tutorial at <A href= - "http://www.intermedia.net/support/sql/sqltut.shtm">http://www.intermedia.net/support/sql/sqltut.shtm,</A> - at <A href= - "http://ourworld.compuserve.com/homepages/graeme_birchall/HTM_COOK.HTM"> - http://ourworld.compuserve.com/homepages/graeme_birchall/HTM_COOK.HTM,</A> - and at <A href= - "http://sqlcourse.com/">http://sqlcourse.com.</A></P> - + <P>There are also many nice tutorials available online: + <UL> + <LI> <A href="http://www.intermedia.net/support/sql/sqltut.shtm">http://www.intermedia.net/support/sql/sqltut.shtm</A> + </LI> + <LI> + <A href="http://sqlcourse.com/">http://sqlcourse.com</A> + </LI> + <LI> + <A href="http://www.w3schools.com/sql/default.asp">http://www.w3schools.com/sql/default.asp</A> + </LI> + <LI><A href= + "http://mysite.verizon.net/Graeme_Birchall/id1.html">http://mysite.verizon.net/Graeme_Birchall/id1.html</A> + </LI> + </UL> + <H3 id="item1.12">1.12) How do I submit a patch or join the development team?</H3> @@ -741,7 +748,7 @@ table?</TD><TD>unlimited</TD></TR> <P>Indexes are normally not used for <SMALL>ORDER BY</SMALL> or to perform joins. A sequential scan followed by an explicit sort is - usually faster than an index scan of a large table.</P> + usually faster than an index scan of a large table. However, <SMALL>LIMIT</SMALL> combined with <SMALL>ORDER BY</SMALL> often will use an index because only a small portion of the table is returned.</P> |