Unix Technical Forum

Postgresql 8.2 AUTOVACUUM LOG

This is a discussion on Postgresql 8.2 AUTOVACUUM LOG within the pgsql Admins forums, part of the PostgreSQL category; --> 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 ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Admins

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 08:18 AM
Jean-Marc Pigeon
 
Posts: n/a
Default Postgresql 8.2 AUTOVACUUM LOG

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


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:34 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com