| From: | Douglas Birdzell <dbirdzell(at)aod(dot)cx> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Cc: | Stephen Bacon <sbacon(at)aod(dot)cx>, Mike Russell <mrussell(at)aod(dot)cx> |
| Subject: | autovacuum running even when not set in config? |
| Date: | 2007-12-10 18:35:51 |
| Message-ID: | 20071210183551.GA11514@nemesis.aod.cx |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
Recently we noticed this autovacuum process running on one of our db
servers, which is running pg 8.2.3.
2273 ? Ds 0:00 postgres: autovacuum process fy2006outcomesdb4091
Autovacuum is off in this machine's config. I verified that by
connecting via psql and running 'show autovacuum'. Also,
pg_autovacuum on this machine has no rows.
Has anyone seen this sort of behavior? Is it normal for autovacuuming
to start up once in a while even when the configuration does not call
for autovacuuming?
Thanks,
Douglas Birdzell
Senior Software Developer
Advanced Outcomes Design
http://www.aod.cx
voice: 202-872-1033
fax: 202-833-9168
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-12-10 18:48:45 | Re: autovacuum running even when not set in config? |
| Previous Message | Joshua D. Drake | 2007-12-10 16:53:29 | Re: [ADMIN] Dangerous hint in the PostgreSQL manual |