Skip site navigation (1) Skip section navigation (2)

Re: autovacuum question

From: Jim Nasby <decibel(at)decibel(dot)org>
To: Laszlo Nagy <gandalf(at)designaproduct(dot)biz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: autovacuum question
Date: 2007-03-26 22:10:05
Message-ID: 3DD60E78-DAB8-49F6-A939-5C7C0E19C582@decibel.org (view raw or flat)
Thread:
Lists: pgsql-admin
Autovacuum doesn't launch a separate daemon; you'll only see an  
autovac process when an autovac is actually working.

Also, 8.1 has code to prevent wraparound, so that's not it (see  
backend/access/transam/varsup.c)

On Mar 27, 2007, at 5:17 AM, Laszlo Nagy wrote:

>
>  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
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2007-03-27 03:37:18
Subject: Re: [GENERAL] ERROR: out of shared memory
Previous:From: Carol WalterDate: 2007-03-26 20:45:01
Subject: data from system tables.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group