Re: autovacuum question

[Thomas Pundt <mlists(at)rp-online(dot)de>]

On Wednesday 04 April 2007 20:40, Carol Walter wrote:
| Hi, I'm looking in my log file with today's date.  I'm using VIM and
| have done a search for a pattern match on "autovac", "vacuum", and
| "auto"  VIM returned "string not found" for each search.  Am I
| looking for the wrong  string, or is there another log file I should
| be looking at?

No; mine has entries like

[::2007-04-05 09:04:10 CEST] LOG:  autovacuum: processing database "postgres"

and the only settings different from default are

  log_min_error_statement = warning
  log_min_duration_statement = 1000
  log_line_prefix = '[%u:%d:%t] '

  autovacuum = on
  autovacuum_naptime = 30
  autovacuum_vacuum_threshold = 500
  autovacuum_analyze_threshold = 250
  autovacuum_vacuum_scale_factor = 0.2
  autovacuum_analyze_scale_factor = 0.1

Ciao,
Thomas

-- 
Thomas Pundt <thomas(dot)pundt(at)rp-online(dot)de> ---- http://rp-online.de/ ----