1. 19 Apr, 2005 1 commit
    • Bruce Momjian's avatar
      The following patch should allow UPDATE_INTERVAL to be specified on the · 7cce39c7
      Bruce Momjian authored
      command line. We find this useful because we frequently deal with
      thousands of tables in an environment where neither the databases nor
      the tables are updated frequently. This helps allow us to cut down on
      the overhead of updating the list for every other primary loop of
      pg_autovacuum.
      
      I chose -i as the command-line argument and documented it briefly in
      the README.
      
      The patch was applied to the 7.4.7 version of pg_autovacuum in contrib.
      
      Thomas F.O'Connell
      7cce39c7
  2. 30 Mar, 2005 1 commit
  3. 24 Jan, 2005 1 commit
  4. 02 Dec, 2004 1 commit
    • Bruce Momjian's avatar
      > > 8.0beta3 has pg_autovacuum included, when I want to run this as a · 9269699b
      Bruce Momjian authored
      > > Windows service, it says you can use the -I and -R options.
      > >
      > > When I do that and I specify a password with '-P'
      > (uppercase) then in
      > > the registry it's saved as '-p' (lowercase) in the
      > service-commandline
      > > (ImagePath).
      
      This was fixed in v1.21 of pg_autovacuum.c, That rev is tagged for
      beta3, so you should not be seeing this issue unless you actually have
      an older version for some reason.
      
      http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_autovacuum/p
      g_autovacuum.c.diff?r1=1.20;r2=1.21;f=h
      
      > > Also it removes the quotes I added and I'm not so sure it
      > would work
      > > the way it's supposed to, without it.
      
      It's not so much that it strips them (that happens automagically), more
      that it doesn't re-add them when it writes the command line in the
      registry. The attached patch fixes that by simply quoting all options
      that may need it.
      > > If you add DependOnService (a REG_MULTI_SZ an
      > array-like-thingie) and
      > > have the name (in this case: pgsql-8.0-beta2-dev3) of a service it
      > > depends on, it will not fail to start (it will not even try, as
      > > PostgreSQL is not running), when PostgreSQL already failed.
      > >
      > > Maybe it's an idea to specify it on the commandline (what
      > service to
      > > depend on).
      
      A -E <service> option is added in the attached patch.
      
      Dave Page
      9269699b
  5. 17 Nov, 2004 2 commits
  6. 14 Sep, 2004 1 commit
  7. 19 Apr, 2004 1 commit
  8. 09 Nov, 2003 1 commit
  9. 16 Oct, 2003 1 commit
  10. 08 Oct, 2003 1 commit
  11. 13 Sep, 2003 1 commit
    • Bruce Momjian's avatar
      > OK, well as we wait on the fix for the stats system, let me submit my · 3bf080da
      Bruce Momjian authored
      > patch for pg_autovacuum.  This patch assumes that the stats system will
      > be fixed so that all inserts, updates and deletes performed on shared
      > tables reguardless of what database those commands were executed from,
      > will show up in the stats shown in each database.
      
      I had to make a further change to this to take quotes off the 'last
      ANALYZE' in order for it to not overquote the relation name, so
      there's a _little_ work left to get it to play well.
      
      I have deployed it onto several boxes that should be doing some
      vacuuming over the weekend, and it is now certainly hitting pg_
      tables.
      
      I would like to present a CVS-oriented patch; unfortunately, I had to
      change the indentation patterns when editing some of it :-(.  The
      following _may_ be good; not sure...
      
      Matthew T. O'Connor
      Christopher Browne
      3bf080da
  12. 12 Jun, 2003 1 commit
    • Bruce Momjian's avatar
      This patch updates pg_autovacuum in several ways: · 9243664d
      Bruce Momjian authored
      * A few bug fixes
      * fixes solaris compile and crash issue
      * decouple vacuum analyze and analyze thresholds
      * detach from tty (dameonize)
      * improved logging layout
      * more conservative default configuration
      * improved, expanded and updated README
      
      please apply and 1st convenience, or before code freeze which ever comes
      first :-)
      
      At this point I think I have brought pg_autovacuum and its client side
      design as far as I think it should go.  It works, keeping file sizes in
      check, helps performance and give the administrator a fair amount
      flexibility in configuring it.
      
      Next up is to do the FSM based design that is integrated into the back
      end.
      
      p.s. Thanks to Christopher Browne for his help.
      
      Matthew T. O'Connor
      9243664d
  13. 23 Mar, 2003 1 commit
  14. 20 Mar, 2003 1 commit
    • Bruce Momjian's avatar
      I have updated my pg_autovacuum program (formerly pg_avd, the name · bd18c50b
      Bruce Momjian authored
      changed as per discussion on the patches list).
      
      This version should be a good bit better.  It addresses all the issues
      pointed out by Neil Conway. Vacuum and Analyze are now handled
      separately.  It now monitors for xid wraparound.  The number of database
      connections and queries has been significantly reduced compared the
      previous version.  I have moved it from bin to contrib.  More detail on
      the changes are in the TODO file.
      
      I have not tested the xid wraparound code as I have to let my AthlonXP
      1600 run select 1 in a tight loop for approx. two days in order to
      perform the required 500,000,000 xacts.
      
      Matthew T. O'Connor
      bd18c50b