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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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">
==========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-15 15:41:42 | Re: backup WAL files, |
Previous Message | Scott Marlowe | 2008-01-15 15:21:52 | Re: update performance 8.1.4 |