Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 859562E021D for ; Tue, 15 Jan 2008 11:32:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 34087-09 for ; Tue, 15 Jan 2008 11:32:39 -0400 (AST) Received: from dublin.safe.ca (Dublin.safe.ca [206.123.20.112]) by postgresql.org (Postfix) with ESMTP id 5A94C2E01AA for ; Tue, 15 Jan 2008 11:32:45 -0400 (AST) Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by dublin.safe.ca (8.14.1/8.14.1) with ESMTP id m0FFWcNg013620 for ; Tue, 15 Jan 2008 10:32:38 -0500 Received: from Mercier.safe.ca (Mercier.safe.ca [192.219.254.50]) by dublin.safe.ca (clement-2.1-275) with SMTP id <206.123.20.112-035477e147dc1@dublin.safe.ca> Tue Jan 15 10:32:29 2008 Subject: Postgresql 8.2 AUTOVACUUM LOG From: Jean-Marc Pigeon To: pgsql-admin@postgresql.org Content-Type: text/plain; charset=UTF-8 Organization: SAFE Inc. Date: Tue, 15 Jan 2008 10:32:27 -0500 Message-Id: <1200411147.2989.39.camel@Mercier.safe.ca> Mime-Version: 1.0 X-Mailer: Evolution 2.12.2 (2.12.2-2.fc8) Content-Transfer-Encoding: 8bit X-Clement-Version: 2.1-275 X-Clement-ID: <206.123.20.112-035477e147dc1> X-Clement-Virus-checker: Clamav-0.92 (virlib:2008-01-14 10:00:20 EST5EDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/156 X-Sequence-Number: 27930 Bonjour a Tous, There is an AUTOVACUUM capability embedded within PostgreSQL 8.2 (fedora core 7, postgresql-8.2.5-1.fc7) How/where can I see in the log if indeed Autovacuum started itself?? How can I trigger Autovacuum execution (as it will do by itself)??? Here is the relevant part of my postgresql.conf ;---------------------------------- #to have autovacuum started autovacuum = true autovacuum_naptime = 1min #debug flag log_min_messages = debug2 client_min_messages = debug2 ;----------------------------------- After days my DB intense activity, I have no proof autovacuum started itself... What am I missing here? Thanks for help or hints. -- A bientôt ========================================================================== Jean-Marc Pigeon Internet: jmp@safe.ca SAFE Inc. Phone: (514) 493-4280 Fax: (514) 493-1946 Clement, 'a kiss solution' to get rid of SPAM (at last) Clement' Home base <"http://www.clement.safe.ca"> ==========================================================================