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/ ----
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 |