From: Laszlo Nagy <gandalf@designaproduct.biz>
To: pgsql-admin@postgresql.org
Subject: autovacuum question
Date: Mon, 26 Mar 2007 19:17:43 +0200
Message-ID: <46080037.9020209@designaproduct.biz> (raw)
Hello,
I had a problem in my computer system yesterday. Some data has
disappeared. I was looking for a program that might have deleted it
accidentally. Before I found anything, the data suddenly came back. I
thought it must be a transaction id wraparound problem.
The system is running on FreeBSD 6.2. Postgresql version is 8.1.8 and it
was installed from FreeBSD's standard ports tree. It also installed a
script that vacuums all databases daily. This script was turned on, and
I got emails every day, telling me that the databases were vacuumed.
However, when I opened some tables from within pgadmin3, I got the
message "pg_autovacuum recommened".
Summary: I'm vacuuming all databases daily, but probably I had a
transaction wraparound.
I thought I should enable autovacuum. I read the docs and did the following:
1. Changed postgresql.conf:
stats_start_collector = on
stats_row_level = on
autovacuum = on
2. Restarted the postgresql service.
Now, I do not see a "separate autovacuum daemon" running. What did I
wrong? Here are my tips:
a.) atovacuum daemon is part of the "postgres" process, so I won't see
it running in the process list (how can I check if it is working?)
b.) there is a separate program that I should start (where?)
c.) I missed some extra configuration (what should I do?)
d.) something else
Please help me out.
Thanks,
Laszlo
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: gandalf@designaproduct.biz
Subject: Re: autovacuum question
In-Reply-To: <46080037.9020209@designaproduct.biz>
* 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