Karl <[hidden email]>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
--- chado/INSTALL.Chado (revision 25293)
+++ chado/INSTALL.Chado (working copy)
@@ -48,6 +48,8 @@
$ createlang plpgsql template1
$ exit # to exit out of the postgres
+ (NOTE: plpgsql is installed automatically in postgres 9.0+.)
* Edit the pg_hba.conf (either as the user 'root' or 'postgres')
the user created above permission to access the database. Read
the comments in pg_hba.conf regarding permissions. An example
@@ -90,8 +92,10 @@
manpage for details. Also critical for continued performance of
postgres is the regular execution of the VACUUM FULL ANALYZE command.
This command clears out old, deleted data and analyzes the structure
-of the database so that the execution planner can predict the
-fastest way to execute a given query.
+of the database so that the execution planner can predict the fastest
+way to execute a given query. Postgres 8.3 and later is configured to
+VACUUM automatically by default, although manual vacuuming may still
While the above link describes tuning in general, the examples given
for tuning kernel parameters are Linux specific. For setting
@@ -216,8 +220,8 @@
-Backward compatibility may not be maintained for this method of
-the install process will work.
+ Warning: Backward compatibility may not be maintained for this
+ method of configuring the install process.
- Create the Makefile and other configuration files