|
10 | 10 | alink="#0000ff"> |
11 | 11 | <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> |
12 | 12 |
|
13 | | -<P>Last updated: Sat Jan 29 23:02:37 EST 2005</P> |
| 13 | +<P>Last updated: Sat Jan 29 23:04:53 EST 2005</P> |
14 | 14 |
|
15 | 15 | <P>Current maintainer: Bruce Momjian (<Ahref= |
16 | 16 | "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> |
@@ -82,8 +82,8 @@ <H2 align="center">Operational Questions</H2> |
82 | 82 | table, and a database?<BR> |
83 | 83 | <Ahref="#4.5">4.5</A>) How much database disk space is required |
84 | 84 | to store data from a typical text file?<BR> |
85 | | -<Ahref="#4.6">4.6</A>)My queriesare slow ordon'tmake use of |
86 | | -the indexes. Why?<BR> |
| 85 | +<Ahref="#4.6">4.6</A>)Whyaremy queriesslow? Whydon'tthey |
| 86 | +make use of indexes?<BR> |
87 | 87 | <Ahref="#4.7">4.7</A>) How do I see how the query optimizer is |
88 | 88 | evaluating my query?<BR> |
89 | 89 | <Ahref="#4.8">4.8</A>) What is an R-tree index?<BR> |
@@ -846,8 +846,8 @@ <H4><A name="4.5">4.5</A>) How much database disk space is required |
846 | 846 | <P><SMALL>NULL</SMALL>s are stored as bitmaps, so they |
847 | 847 | use very little space.</P> |
848 | 848 |
|
849 | | -<H4><Aname="4.6">4.6</A>)My queriesare slow ordon'tmake use of |
850 | | -the indexes. Why?</H4> |
| 849 | +<H4><Aname="4.6">4.6</A>)Whyaremy queriesslow? Whydon'tthey |
| 850 | +make use of indexes?</H4> |
851 | 851 |
|
852 | 852 | <P>Indexes are not automatically used by every query. Indexes are only |
853 | 853 | used if the table is larger than a minimum size, and the query |
|