From: Thomas Pundt <mlists@rp-online.de>
To: pgsql-admin@postgresql.org, Carol Walter <walterc@indiana.edu>
Subject: Re: autovacuum question
Date: Thu, 5 Apr 2007 09:19:43 +0200
Message-ID: <200704050919.44002.mlists@rp-online.de> (raw)
In-Reply-To: <64A326CC-DA58-4D62-96FB-207776D90495@indiana.edu>
References: <EDBC231C-B790-4F75-A798-764ECA1E123E@indiana.edu>
<200703301659.41322.mlists@rp-online.de>
<64A326CC-DA58-4D62-96FB-207776D90495@indiana.edu>
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/ ----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mlists@rp-online.de, walterc@indiana.edu
Subject: Re: autovacuum question
In-Reply-To: <200704050919.44002.mlists@rp-online.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox