diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-10-16 03:47:28 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-10-16 03:47:28 +0000 |
| commit | 62fdc3dd60a7db08e143c33c00062d25c820adc7 (patch) | |
| tree | 3c5fd32105c29389b4259963d5f62b5e9e143dda /contrib/pg_autovacuum | |
| parent | 37278c063fed8b7e10f8ad5fe7cab7f809df2770 (diff) | |
| download | postgresql-62fdc3dd60a7db08e143c33c00062d25c820adc7.tar.gz | |
I have run pg_autovacuum on AIX, so that can, at least loosely, be
considered "tested."
And I have turned all of the 7.4 HISTORY material into DocBook for
release.sgml
Christopher Browne
Diffstat (limited to 'contrib/pg_autovacuum')
| -rw-r--r-- | contrib/pg_autovacuum/README.pg_autovacuum | 21 |
1 files changed, 14 insertions, 7 deletions
diff --git a/contrib/pg_autovacuum/README.pg_autovacuum b/contrib/pg_autovacuum/README.pg_autovacuum index 31d63dfe8f..e14dd5153e 100644 --- a/contrib/pg_autovacuum/README.pg_autovacuum +++ b/contrib/pg_autovacuum/README.pg_autovacuum @@ -30,15 +30,17 @@ KNOWN ISSUES: ------------- pg_autovacuum has been tested under Redhat Linux (by me) and Debian -GNU/Linux and Solaris (by Christopher B. Browne) and all known bugs -have been resolved. Please report any problems to the hackers list. +GNU/Linux, Solaris, and AIX (by Christopher B. Browne) and all known +bugs have been resolved. Please report any problems to the hackers +list. pg_autovacuum requires that the statistics system be enabled and reporting row level stats. The overhead of the stats system has been -shown to have a significant cost under certain workloads. For instance, -a tight loop of queries performing "select 1" was found to run nearly -30% slower when stats were enabled. However, in practice, with more -realistic workloads, the stats system overhead is usually nominal. +shown to have a significant cost under certain workloads. For +instance, a tight loop of queries performing "select 1" was found to +run nearly 30% slower when stats were enabled. However, in practice, +with more realistic workloads, the stats system overhead is usually +nominal. pg_autovacuum does not get started automatically by either the postmaster 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 introduce this sort of functionality by providing arguments to specify the database and schema in which to find a configuration table. +It would also be desirable for the daemon to monitor how busy the +system is, with a view to deferring vacuums until there is less other +activity. + INSTALL: -------- @@ -78,7 +84,8 @@ installed for you. If you are using an earlier version of PostgreSQL, uncompress the tar.gz file into the contrib directory and modify the contrib/Makefile to include the pg_autovacuum directory. pg_autovacuum will then be -built as part of the standard postgresql install. +built as part of the standard postgresql install. It is known to work +with v7.3 releases; it is not presently compatible with v7.2. make sure that the following are set in postgresql.conf: |