I have a couple of postgres 8.3 databases, and they are showing symptoms of lack of vacuuming.
I've checked the config, and they are in the default state of having the autovacummer turned on. Also, I see in my postgres logs "autovacuum launcher started" when I start the database.
The problem is, I never actually see a vacuum running. I also never see anything in the logs about a vacuum taking place (should I be seeing anything?)
So how do I tell if the vacuumer is working? Is there a way to see when the last vacuum completed, for example? Better yet, is there some documentation someone can point me to with the answer to that question?