Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7A84F9FB62A for ; Thu, 5 Apr 2007 04:17:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 92952-06 for ; Thu, 5 Apr 2007 04:17:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.rp-online.de (mail.rp-online.de [149.221.1.199]) by postgresql.org (Postfix) with ESMTP id 9AECC9FB551 for ; Thu, 5 Apr 2007 04:17:02 -0300 (ADT) Received: from idefix.d.rp-online.de (idefix.d.rp-online.de [149.221.100.194]) by mail.rp-online.de (Postfix) with ESMTP id 67FE32FEAB; Thu, 5 Apr 2007 09:17:01 +0200 (CEST) From: Thomas Pundt Reply-To: Thomas Pundt Organization: RP Online GmbH To: pgsql-admin@postgresql.org, Carol Walter Subject: Re: autovacuum question Date: Thu, 5 Apr 2007 09:19:43 +0200 User-Agent: KMail/1.9.4 References: <200703301659.41322.mlists@rp-online.de> <64A326CC-DA58-4D62-96FB-207776D90495@indiana.edu> In-Reply-To: <64A326CC-DA58-4D62-96FB-207776D90495@indiana.edu> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200704050919.44002.mlists@rp-online.de> X-Anti-Virus: Kaspersky Anti-Virus for MailServers 5.5.10/RELEASE, bases: 05042007 #275190, status: clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/53 X-Sequence-Number: 25117 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 ---- http://rp-online.de/ ----