1. 24 Sep, 2007 1 commit
    • Tom Lane's avatar
      Simplify and rename some GUC variables, per various recent discussions: · 48f7e643
      Tom Lane authored
      * stats_start_collector goes away; we always start the collector process,
      unless prevented by a problem with setting up the stats UDP socket.
      
      * stats_reset_on_server_start goes away; it seems useless in view of the
      availability of pg_stat_reset().
      
      * stats_block_level and stats_row_level are merged into a single variable
      "track_counts", which controls all reports sent to the collector process.
      
      * stats_command_string is renamed to track_activities.
      
      * log_autovacuum is renamed to log_autovacuum_min_duration to better reflect
      its meaning.
      
      The log_autovacuum change is not a compatibility issue since it didn't exist
      before 8.3 anyway.  The other changes need to be release-noted.
      48f7e643
  2. 14 Sep, 2007 2 commits
  3. 13 Sep, 2007 1 commit
  4. 19 Aug, 2007 1 commit
  5. 23 Jul, 2007 1 commit
  6. 18 Jul, 2007 1 commit
  7. 30 May, 2007 1 commit
  8. 15 May, 2007 1 commit
  9. 03 May, 2007 1 commit
  10. 18 Apr, 2007 1 commit
  11. 16 Apr, 2007 1 commit
    • Alvaro Herrera's avatar
      Add a multi-worker capability to autovacuum. This allows multiple worker · e2a186b0
      Alvaro Herrera authored
      processes to be running simultaneously.  Also, now autovacuum processes do not
      count towards the max_connections limit; they are counted separately from
      regular processes, and are limited by the new GUC variable
      autovacuum_max_workers.
      
      The launcher now has intelligence to launch workers on each database every
      autovacuum_naptime seconds, limited only on the max amount of worker slots
      available.
      
      Also, the global worker I/O utilization is limited by the vacuum cost-based
      delay feature.  Workers are "balanced" so that the total I/O consumption does
      not exceed the established limit.  This part of the patch was contributed by
      ITAGAKI Takahiro.
      
      Per discussion.
      e2a186b0
  12. 01 Feb, 2007 2 commits
  13. 31 Jan, 2007 2 commits
    • Bruce Momjian's avatar
      Update documentation on may/can/might: · a134ee33
      Bruce Momjian authored
      Standard English uses "may", "can", and "might" in different ways:
      
              may - permission, "You may borrow my rake."
      
              can - ability, "I can lift that log."
      
              might - possibility, "It might rain today."
      
      Unfortunately, in conversational English, their use is often mixed, as
      in, "You may use this variable to do X", when in fact, "can" is a better
      choice.  Similarly, "It may crash" is better stated, "It might crash".
      
      Also update two error messages mentioned in the documenation to match.
      a134ee33
    • Bruce Momjian's avatar
      08674935
  14. 16 Jan, 2007 1 commit
  15. 27 Dec, 2006 1 commit
  16. 05 Nov, 2006 1 commit
    • Tom Lane's avatar
      Fix recently-understood problems with handling of XID freezing, particularly · 48188e16
      Tom Lane authored
      in PITR scenarios.  We now WAL-log the replacement of old XIDs with
      FrozenTransactionId, so that such replacement is guaranteed to propagate to
      PITR slave databases.  Also, rather than relying on hint-bit updates to be
      preserved, pg_clog is not truncated until all instances of an XID are known to
      have been replaced by FrozenTransactionId.  Add new GUC variables and
      pg_autovacuum columns to allow management of the freezing policy, so that
      users can trade off the size of pg_clog against the amount of freezing work
      done.  Revise the already-existing code that forces autovacuum of tables
      approaching the wraparound point to make it more bulletproof; also, revise the
      autovacuum logic so that anti-wraparound vacuuming is done per-table rather
      than per-database.  initdb forced because of changes in pg_class, pg_database,
      and pg_autovacuum catalogs.  Heikki Linnakangas, Simon Riggs, and Tom Lane.
      48188e16
  17. 23 Oct, 2006 1 commit
  18. 16 Sep, 2006 1 commit
  19. 29 Aug, 2006 1 commit
  20. 28 Aug, 2006 1 commit
  21. 04 Aug, 2006 1 commit
  22. 01 Aug, 2006 2 commits
  23. 18 Jun, 2006 1 commit
  24. 23 Apr, 2006 1 commit
  25. 10 Mar, 2006 1 commit
  26. 07 Dec, 2005 2 commits
  27. 04 Nov, 2005 1 commit
  28. 01 Nov, 2005 1 commit
  29. 21 Oct, 2005 1 commit
  30. 23 Sep, 2005 1 commit
  31. 16 Sep, 2005 1 commit
  32. 13 Sep, 2005 1 commit
  33. 22 Jun, 2005 1 commit
  34. 13 Jun, 2005 1 commit
  35. 10 May, 2005 1 commit