Skip site navigation (1) Skip section navigation (2)

Postgresql 8.2 AUTOVACUUM LOG

From: Jean-Marc Pigeon <jmp(at)safe(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgresql 8.2 AUTOVACUUM LOG
Date: 2008-01-15 15:32:27
Message-ID: 1200411147.2989.39.camel@Mercier.safe.ca (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)safe(dot)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">
==========================================================================


pgsql-admin by date

Next:From: Tom LaneDate: 2008-01-15 15:41:42
Subject: Re: backup WAL files,
Previous:From: Scott MarloweDate: 2008-01-15 15:21:52
Subject: Re: update performance 8.1.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group