|
1 | 1 | <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 3.2//EN"> |
2 | | -<!-- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 3.2//EN"> --> |
3 | 2 |
|
4 | 3 | <HTML> |
5 | 4 | <HEAD> |
|
12 | 11 | alink="#0000FF"> |
13 | 12 | <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1> |
14 | 13 |
|
15 | | -<P>Last updated: Wed Dec 5 00:33:46 EST 2001</P> |
| 14 | +<P>Last updated: Wed Dec 5 00:38:51 EST 2001</P> |
16 | 15 |
|
17 | 16 | <P>Current maintainer: Bruce Momjian (<Ahref= |
18 | 17 | "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> |
@@ -485,8 +484,10 @@ <H4><A name="1.15">1.15</A>) How can I financially assist PostgreSQL?</H4> |
485 | 484 | you or your company has money it can donate to help fund this effort, |
486 | 485 | please go to the following URL and make a donation: |
487 | 486 |
|
| 487 | +<UL> |
488 | 488 | <P><ahref="http://www.pgsql.com/pg_goodies">http://www.pgsql.com/pg_goodies</a> |
489 | | - |
| 489 | +</UL> |
| 490 | + |
490 | 491 | <P>Although the web page mentions PostgreSQL, Inc, the "contributions" item |
491 | 492 | is solely to support the PostgreSQL project and does not fund any |
492 | 493 | specific company. If you prefer, you can also send a check to the |
@@ -846,13 +847,13 @@ <H4><A name="4.6">4.6</A>) What is the maximum size for a row, |
846 | 847 |
|
847 | 848 | <P>These are the limits:</P> |
848 | 849 | <PRE> |
849 | | -Maximum size for a database? unlimited (60GB databases exist) |
850 | | -Maximum size for a table? 16 TB |
851 | | -Maximum size for a row? unlimited in 7.1 and later |
852 | | -Maximum size for a field? 1GB in 7.1 and later |
853 | | -Maximum number of rows in a table? unlimited |
854 | | -Maximum number of columns in a table? 250-1600 depending on column types |
855 | | -Maximum number of indexes on a table? unlimited |
| 850 | +Maximum size for a database? unlimited (60GB databases exist) |
| 851 | +Maximum size for a table? 16 TB |
| 852 | +Maximum size for a row? unlimited in 7.1 and later |
| 853 | +Maximum size for a field? 1GB in 7.1 and later |
| 854 | +Maximum number of rows in a table? unlimited |
| 855 | +Maximum number of columns in a table? 250-1600 depending on column types |
| 856 | +Maximum number of indexes on a table? unlimited |
856 | 857 | </PRE> |
857 | 858 | Of course, these are not actually unlimited, but limited to |
858 | 859 | available disk space and memory/swap space. Performance may suffer |
@@ -1297,7 +1298,7 @@ <H4><A name="4.24">4.24</A>) How do I perform an outer join?<BR> |
1297 | 1298 | </PRE> |
1298 | 1299 |
|
1299 | 1300 | <H4><Ahref="#4.25">4.25</A>) How do I perform queries |
1300 | | - using multiple databases?<H4> |
| 1301 | + using multiple databases?</H4> |
1301 | 1302 |
|
1302 | 1303 | <P>There is no way to query any database except the current one. |
1303 | 1304 | Because PostgreSQL loads database-specific system catalogs, it is |
|