pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jean-Marc Pigeon <jmp@safe.ca>
To: pgsql-admin@postgresql.org
Subject: Postgresql 8.2 AUTOVACUUM LOG
Date: Tue, 15 Jan 2008 10:32:27 -0500
Message-ID: <1200411147.2989.39.camel@Mercier.safe.ca> (raw)

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";
==========================================================================




Message-ID: <1200411147.2989.39.camel@Mercier.safe.ca>
Permalink:  ../1200411147.2989.39.camel@Mercier.safe.ca/
Also on:    postgresql.org/message-id/1200411147.2989.39.camel@Mercier.safe.ca

 · 

reply

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: jmp@safe.ca
  Subject: Re: Postgresql 8.2 AUTOVACUUM LOG
  In-Reply-To: <1200411147.2989.39.camel@Mercier.safe.ca>

* 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