Re: autovacuum question

From: Thomas Pundt <mlists(at)rp-online(dot)de>
To: pgsql-admin(at)postgresql(dot)org, Carol Walter <walterc(at)indiana(dot)edu>
Subject: Re: autovacuum question
Date: 2007-04-05 07:19:43
Message-ID: 200704050919.44002.mlists@rp-online.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)pundt(at)rp-online(dot)de> ---- http://rp-online.de/ ----

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message sufian khan 2007-04-05 10:50:18 information about postgresql
Previous Message Bellur Ashwin 2007-04-05 06:40:11 Re: xlog related error