From 876ef5d5c9bc753dd8c097bf8ad13616af1300f4 Mon Sep 17 00:00:00 2001
From: Bruce Momjian Last updated: Mon Dec 11 17:44:33 EST 2006 Last updated: Mon Dec 11 17:45:54 EST 2006 Current maintainer: Bruce Momjian (bruce@momjian.us)
@@ -42,7 +42,7 @@
development team? PostgreSQL does not use a bug tracking system because we find
it more efficient to respond directly to email and keep the
TODO
@@ -318,7 +318,7 @@
CVS
log messages. Even the release notes do not list every change
made to the software. PostgreSQL includes extensive documentation, including a large
@@ -370,7 +370,7 @@
"http://mysite.verizon.net/Graeme_Birchall/id1.html">http://mysite.verizon.net/Graeme_Birchall/id1.html
-
+
There are three major areas for potential performance
improvement:Frequently Asked Questions (FAQ) for PostgreSQL
-
1.13) How does PostgreSQL compare to other
DBMSs?
-
+
User Client Questions
2.1) What interfaces are available for
@@ -51,7 +51,7 @@
PostgreSQL with Web pages?
2.3) Does PostgreSQL have a graphical user
interface?
-
+
Administrative Questions
3.1) How do I install PostgreSQL somewhere other
@@ -281,7 +281,7 @@
-
+
1.9) How do I find out about known bugs or
missing features?
@@ -307,7 +307,7 @@
1.10) What documentation is available?
1.12) How do I submit a patch or join the development
team?
@@ -503,7 +503,7 @@
Major releases (e.g. from 7.3 to 7.4) often change the internal format of system tables and data files. These changes are often complex, so we don't maintain backward compatibility for data files. A dump/reload @@ -638,7 +638,7 @@
There are also system tables beginning with pg_ that describe these too.
- +Use psql -l will list all databases.
Also try the file pgsql/src/tutorial/syscat.source. It @@ -660,7 +660,7 @@
You might then want to do VACUUM FULL tab to reclaim the disk space used by the expired rows.
- +NULLs are stored as bitmaps, so they use very little space.
- +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 index scan is indeed faster.
To sort by the NULL status, use the IS NULL and IS NOT NULL modifiers in your ORDER BY clause. Things that are true will sort higher than things that are false, @@ -948,7 +948,7 @@ length execute("INSERT INTO person (name) VALUES ('Blaise Pascal')"); new_id = execute("SELECT currval('person_id_seq')"); - +