Re: autovacuum question - Mailing list pgsql-admin

From Thomas Pundt
Subject Re: autovacuum question
Date
Msg-id 200704050919.44002.mlists@rp-online.de
Whole thread Raw
In response to Re: autovacuum question  (Carol Walter <walterc@indiana.edu>)
List pgsql-admin
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.pundt@rp-online.de> ---- http://rp-online.de/ ----

pgsql-admin by date:

Previous
From: Bellur Ashwin
Date:
Subject: Re: xlog related error
Next
From: sufian khan
Date:
Subject: information about postgresql