@@ -30,15 +30,17 @@ KNOWN ISSUES:
3030-------------
3131
3232pg_autovacuum has been tested under Redhat Linux (by me) and Debian
33- GNU/Linux and Solaris (by Christopher B. Browne) and all known bugs
34- have been resolved. Please report any problems to the hackers list.
33+ GNU/Linux, Solaris, and AIX (by Christopher B. Browne) and all known
34+ bugs have been resolved. Please report any problems to the hackers
35+ list.
3536
3637pg_autovacuum requires that the statistics system be enabled and
3738reporting row level stats. The overhead of the stats system has been
38- shown to have a significant cost under certain workloads. For instance,
39- a tight loop of queries performing "select 1" was found to run nearly
40- 30% slower when stats were enabled. However, in practice, with more
41- realistic workloads, the stats system overhead is usually nominal.
39+ shown to have a significant cost under certain workloads. For
40+ instance, a tight loop of queries performing "select 1" was found to
41+ run nearly 30% slower when stats were enabled. However, in practice,
42+ with more realistic workloads, the stats system overhead is usually
43+ nominal.
4244
4345pg_autovacuum does not get started automatically by either the
4446postmaster or by pg_ctl. Similarly, when the postmaster exits, no one
@@ -67,6 +69,10 @@ excluded from being vacuumed. It would probably make sense to
6769introduce this sort of functionality by providing arguments to specify
6870the database and schema in which to find a configuration table.
6971
72+ It would also be desirable for the daemon to monitor how busy the
73+ system is, with a view to deferring vacuums until there is less other
74+ activity.
75+
7076INSTALL:
7177--------
7278
@@ -78,7 +84,8 @@ installed for you.
7884If you are using an earlier version of PostgreSQL, uncompress the
7985tar.gz file into the contrib directory and modify the contrib/Makefile
8086to include the pg_autovacuum directory. pg_autovacuum will then be
81- built as part of the standard postgresql install.
87+ built as part of the standard postgresql install. It is known to work
88+ with v7.3 releases; it is not presently compatible with v7.2.
8289
8390make sure that the following are set in postgresql.conf:
8491